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.
petey wrote:
Are you connected to the relevant instance before running the extended stored procedure? You cannot connect to instance A and run the extended stored procedure to change the settings for instance B, although they are both on the same server.
Correct, I am on the target instance attempting to change the settings for that particular instance. / comments
petey wrote:
Are you connected to the relevant instance before running the extended stored procedure? You cannot connect to instance A and run the extended stored procedure to change the settin...
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...
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...
Is this SQL Multi Script going to be integrated into the application any time soon?
Is there anyway to have it read from your registered servers in SQLBU or SSMS? I have quite a few servers that I'm going to want to make several changes to using this tool once I get that procedure working.
Thanks / comments
Is this SQL Multi Script going to be integrated into the application any time soon?
Is there anyway to have it read from your registered servers in SQLBU or SSMS? I have quite a few servers that I'...