Activity overview
Latest activity by Adam.Bean
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 ...
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???
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?
CONVERT as a seperate utility?
Does Red-Gate or any user have a utility that will CONVERT a Red-Gate SQL Backup to Native backup without having an install of SQL Backup?
This would be extremely handy in our environment to allow ...
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...
Group NT permission problems
Error 880: BACKUP DATABASE permission denied in database: (admin)
SQL error 15404: Could not obtain information about Windows NT group/user 'domain\beana', error code 0x5.
When using SSMS or SQLBU...
Ah ok, thanks yet again. / comments
Ah ok, thanks yet again.
Another random small problem ...
If you use the SQL Multi Script to update the email tab (SMTPHost, SMTPSender) and refresh your connection, the tab does not update until you restart the SQL BU application. The file/logging tab works fine on refresh though. / comments
Another random small problem ...
If you use the SQL Multi Script to update the email tab (SMTPHost, SMTPSender) and refresh your connection, the tab does not update until you restart the SQL BU app...
petey wrote:
Does the SQL Backup Agent service startup user have rights to create/edit entries in that registry key? It appears not to be the case. Could you try using the SQL Backup GUI, enter some settings, and see if they get written to the registry?
Thanks.
Ok, I just had to refresh ...
It does work, but the return from the procedure is nothing. Is this normal? / comments
petey wrote:
Does the SQL Backup Agent service startup user have rights to create/edit entries in that registry key? It appears not to be the case. Could you try using the SQL Backup GUI, ente...