Comments
Sort by recent activity
Are you saying it splits it up in the amount of threads that it was backed up as? You don't have the ability to change that on the convert??? / comments
Are you saying it splits it up in the amount of threads that it was backed up as? You don't have the ability to change that on the convert???
That's a bummer ...
So what is the performance increase by using multiple threads on backups? I'm wondering If I should just leave it single threaded then ... / comments
That's a bummer ...
So what is the performance increase by using multiple threads on backups? I'm wondering If I should just leave it single threaded then ...
Very cool, thanks for the info.
When using that tool, why does it split the backup file in 14 smaller files when converting? / comments
Very cool, thanks for the info.
When using that tool, why does it split the backup file in 14 smaller files when converting?
RedGate advised me to add permissions on some registry folders ... this is what I sent them:
On x64 servers, Software\Red Gate\SQL Backup does not exist.
The path is, Software\Wow6432Node\Red Gate\SQL Backup.
Also, SOFTWARE\Red Gate\SQL Backup\InstalledInstances does not exist under that path nor Wow6432Node.
Anyways, I gave read permissions to the following per your instructions:
HKLM\Software\Microsoft\MSSQLServer\Setup
HKLM\Software\Microsoft\Microsoft SQL Server HKLM\Software\Wow6432Node\Microsoft\Microsoft SQL Server HKLM\Software\Wow6432Node\Red Gate\SQL Backup
And it is still failing.
Please advise...
Thank you
Any thoughts? / comments
RedGate advised me to add permissions on some registry folders ... this is what I sent them:
On x64 servers, Software\Red Gate\SQL Backup does not exist.
The path is, Software\Wow6432Node\Red Gate\...
Jason Cook wrote:
1) Does the SQL Backup Agent have sufficient permissions to perform the backup (otherwise it will be unable to execute)
- Yes, it is running under a domain admin account
Jason Cook wrote:
2) Does the caller have sufficient permissions to issue a BACKUP statement on that database (otherwise it will introduce security vulnerabilities)
- Yes, I have box and sql admin against the target server.
As stated, If I make myself a login as NT ... domain\BEANA and make myself a sysadmin, it works. If I am part of BuiltinAdmins or another NT group managed by AD, it does not work.
The problem seems to be purely with using NT groups. / comments
Jason Cook wrote:
1) Does the SQL Backup Agent have sufficient permissions to perform the backup (otherwise it will be unable to execute)
- Yes, it is running under a domain admin account
Jaso...
Ah ok, thanks yet again. / comments
Ah ok, thanks yet again.