Comments
Sort by recent activity
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'...
Perfect, thanks for the explanation! / comments
Perfect, thanks for the explanation!
petey wrote:
The settings are stored in the registry, under the HKLM\Software\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name> key.
What about x64 servers?
I see SQLBackup under HKLM\Wow6432Node\RedGate\SQLBackup, but the path ends there ...
I tried on a 32bit server, and it didn't seem to work ...
EXEC master..sqbutility 1040, 'BackupFileName', '<DATABASE>'
EXEC master..sqbutility 1040, 'SMTPHost ', 'removed'
EXEC master..sqbutility 1040, 'SMTPSender', 'removed'
EXEC master..sqbutility 1041, 'LogDeleteHours', 7
0 results, registry remains the same.
Thanks again / comments
petey wrote:
The settings are stored in the registry, under the HKLM\Software\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name> key.
What about x64 servers?
I see SQLBackup under HKLM\W...
How do you find the first parameter value?
Also, these registry settings are on the target servers, so this still wouldn't allow me to set a default/make changes to all servers at the same time without connecting to the remote registry. This is where that multi script app comes into play correct?
Thanks / comments
How do you find the first parameter value?
Also, these registry settings are on the target servers, so this still wouldn't allow me to set a default/make changes to all servers at the same time wit...
Thanks, I'll start looking into that.
Is this a planned change in an upcoming version? / comments
Thanks, I'll start looking into that.
Is this a planned change in an upcoming version?
Ah ok, I must have missed that step (first time we're putting this into place) to rename the job. I have not yet found out how to create/save templates, but is job name part of the template?
As for the owner of the job, is that something that will be addressed down the line? For an environment such as ours that has DMZ restrictions, this is very inconvenient. Really we just want to run all of our jobs under SA ...
Thanks for the response / comments
Ah ok, I must have missed that step (first time we're putting this into place) to rename the job. I have not yet found out how to create/save templates, but is job name part of the template?
As for...
We are having the same problem with NT groups to a different domain with in our network. Have you found any resolution to this problem?
Thanks / comments
We are having the same problem with NT groups to a different domain with in our network. Have you found any resolution to this problem?
Thanks