Comments
Sort by recent activity
Fixed..
Restarting the "backup" service on the server cleared the error.
Surinder.. / comments
Fixed..
Restarting the "backup" service on the server cleared the error.
Surinder..
I have granted the RG Backup service "Full Access" to this registry location. Now the SP does change the value as expected
Just done a test run and the alerts are coming through now as expected.
Thanks,
Surinder.. / comments
I have granted the RG Backup service "Full Access" to this registry location. Now the SP does change the value as expected
Just done a test run and the alerts are coming through now as expected.
T...
Nope, the value doesnt change / comments
Nope, the value doesnt change
Extract of the registry
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal]
[HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\(LOCAL)]
"DataPath"="C:\\Documents and Settings\\All Users\\Application Data\\Red Gate\\SQL Backup\\Data\\(local)"
"ServiceLogin"=""
"CopiedVersion4Settings"=dword:00000001
"BackupFolder"="\\\\vipsii\\SQLServerBackups\\<SERVER>\\<DATABASE>\\"
"BackupFileName"="<TYPE>_<SERVER>_<DATABASE>_<DATETIME yyyymmdd_hhnn>"
"LogFolder"="C:\\Documents and Settings\\All Users\\Application Data\\Red Gate\\SQL Backup\\Log\\(LOCAL)\\"
"LogDelete"=dword:00000000
"LogDeleteHours"=dword:00000870
"LogDeleteOptions"=dword:00000000
"MSDBDelete"=dword:00000000
"MSDBDeleteHours"=dword:00000870
"SMTPHost"="Mail"
"SMTPPort"=dword:00000019
"SMTPUserName"=""
"SMTPPassword"=""
"SMTPSender"="SQL-RG@EVSql"
The server is "Windows 2003 R2 Enterprise x32" / comments
Extract of the registry
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal]
[HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGl...
No, and looking at the other values that have come back, its not getting any of the settings.
i.e. The SMTPSender, BAckup location is not right as well
SMTPHost= SMTPPort=25 SMTPUserName= SMTPPassword= SMTPSender=SQLBackup@EVSQL BackupFolder=C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup BackupFileName= LogDeleteOptions=0 LogDeleteHours=2160 LogDelete=0 LogFolder=C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\(LOCAL)\ MSDBDeleteHours=2160 MSDBDelete=0 MaxDataBlock=0 MaxTransferSize=0 VDITimeout=30 SkipChecks=1
Just checked the settings via the GUI, and it has also gone back to default settings. But the settings in the registry are still correct. / comments
No, and looking at the other values that have come back, its not getting any of the settings.
i.e. The SMTPSender, BAckup location is not right as well
SMTPHost= SMTPPort=25 SMTPUserName= SMTPPa...
The value is there. and compared to the other servers all the other values seem correct.
Could it be a permissions problem on the key? what should the security be? / comments
The value is there. and compared to the other servers all the other values seem correct.
Could it be a permissions problem on the key? what should the security be?
In that case the permissions seem fine. All other settings are being picked up from there, ie. backup location etc. Just not the SMTP host. / comments
In that case the permissions seem fine. All other settings are being picked up from there, ie. backup location etc. Just not the SMTP host.
Hi,
After playing around with it yesterday afternoon, I can confirm that it does work as expected. So it does seem to a false warning. / comments
Hi,
After playing around with it yesterday afternoon, I can confirm that it does work as expected. So it does seem to a false warning.
Hi,
It's build 31222 / comments
Hi,
It's build 31222
Hi Brian,
This backup file was not created on that night, but has worked since. I have checked the disks and they all seem fine, no bad sectors etc. / comments
Hi Brian,
This backup file was not created on that night, but has worked since. I have checked the disks and they all seem fine, no bad sectors etc.