Comments
Sort by recent activity
Fixed me, too. Thank you for the quick response! / comments
Fixed me, too. Thank you for the quick response!
I am running Windows 2008 Server x64, SQL Server 2008, and SQL Backup v6.1
I Added the suggested key:
[HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\(LOCAL)]
"SkipChecks"=dword:00000001
I am still unable to execute scheduled backups with the following error message appearing for every attempted database backup in the redgate logs:
8/3/2009 7:06:39 PM: Backing up model (transaction log) to:
8/3/2009 7:06:39 PM: E:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Backup\LOG_(local)_model_20090803_190639.sqb
8/3/2009 7:06:39 PM: Error 880: BACKUP DATABASE permission denied in database: (model)
8/3/2009 7:06:39 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'SERVER\MSSQLAGENT' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.
As I am sure you are aware, MSDN suggests of SQL 2008 (http://msdn.microsoft.com/en-us/library/ms186297.aspx):
SETUSER is included for backward compatibility only. SETUSER may not be supported in a future release of SQL Server. We recommend that you use EXECUTE AS instead.
The article also states:
Only use SETUSER with SQL Server users. SETUSER is not supported with Windows users.
Do I need to change my SQL Agent account to run under a SQL Server User? Do you have any other suggestions?
Thank you. / comments
I am running Windows 2008 Server x64, SQL Server 2008, and SQL Backup v6.1
I Added the suggested key:
[HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\(LOCAL)]
"SkipChecks"=dwo...