Backup Fails with Permission error on 'sqdmemory'
micahlmartin
Posts: 2
Everytime I try to run a back up it fails. I've made sure Network Service was added to the administrators role. I'm running on Windows 7
Here's the trace from Sql Profiler
Backing up MyDatabase (full database) to: E:\Databases\MSSQL\Backups\FULL_(local)_MyDatabase_20120221_113012.sqb VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. Check that the SQL Server instance is running, that you have the SQL Server System Administrator server role; and that no other processes are blocking the backup or restore process; or try increasing the value of the VDITimeout registry setting in HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\[InstanceName] SPID Status Login HostName BlkBy DBName Command CPUTime DiskIO LastBatch ProgramName SPID_1 REQUESTID ----- ------------------------------ -------------------------------------------------------- -------- ----- ------ ----------- ------- ------ -------------- ------------------ ------ --------- 53 RUNNABLE NT AUTHORITY\NETWORK SERVICE MICAH-PC . master SELECT INTO 0 0 02/21 11:30:12 SQBCoreService.exe 53 0 SQL error 3013: BACKUP DATABASE is terminating abnormally. SQL error 262: BACKUP DATABASE permission denied in database 'MyDatabase'. Failed to obtain memory status: SQL error 229: The EXECUTE permission was denied on the object 'sqbmemory', database 'master', schema 'dbo'. Warning 300: Backup failed. Retry attempt: 1 VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. Check that the SQL Server instance is running, that you have the SQL Server System Administrator server role; and that no other processes are blocking the backup or restore process; or try increasing the value of the VDITimeout registry setting in HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\[InstanceName] SPID Status Login HostName BlkBy DBName Command CPUTime DiskIO LastBatch ProgramName SPID_1 REQUESTID ----- ------------------------------ -------------------------------------------------------- -------- ----- ------ ----------- ------- ------ -------------- ------------------ ------ --------- 53 RUNNABLE NT AUTHORITY\NETWORK SERVICE MICAH-PC . master SELECT INTO 15 0 02/21 11:30:44 SQBCoreService.exe 53 0 SQL error 3013: BACKUP DATABASE is terminating abnormally. SQL error 262: BACKUP DATABASE permission denied in database 'MyDatabase'. Failed to obtain memory status: SQL error 229: The EXECUTE permission was denied on the object 'sqbmemory', database 'master', schema 'dbo'. Warning 300: Backup failed. Retry attempt: 2 VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. Check that the SQL Server instance is running, that you have the SQL Server System Administrator server role; and that no other processes are blocking the backup or restore process; or try increasing the value of the VDITimeout registry setting in HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\[InstanceName] SPID Status Login HostName BlkBy DBName Command CPUTime DiskIO LastBatch ProgramName SPID_1 REQUESTID ----- ------------------------------ -------------------------------------------------------- -------- ----- ------ ----------- ------- ------ -------------- ------------------ ------ --------- 53 RUNNABLE NT AUTHORITY\NETWORK SERVICE MICAH-PC . master SELECT INTO 15 0 02/21 11:31:16 SQBCoreService.exe 53 0 SQL error 3013: BACKUP DATABASE is terminating abnormally. SQL error 262: BACKUP DATABASE permission denied in database 'MyDatabase'. Failed to obtain memory status: SQL error 229: The EXECUTE permission was denied on the object 'sqbmemory', database 'master', schema 'dbo'. Warning 300: Backup failed. Retry attempt: 3 VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. Check that the SQL Server instance is running, that you have the SQL Server System Administrator server role; and that no other processes are blocking the backup or restore process; or try increasing the value of the VDITimeout registry setting in HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\[InstanceName] SPID Status Login HostName BlkBy DBName Command CPUTime DiskIO LastBatch ProgramName SPID_1 REQUESTID ----- ------------------------------ -------------------------------------------------------- -------- ----- ------ ----------- ------- ------ -------------- ------------------ ------ --------- 53 RUNNABLE NT AUTHORITY\NETWORK SERVICE MICAH-PC . master SELECT INTO 31 0 02/21 11:31:48 SQBCoreService.exe 53 0 SQL error 3013: BACKUP DATABASE is terminating abnormally. SQL error 262: BACKUP DATABASE permission denied in database 'MyDatabase'. Failed to obtain memory status: SQL error 229: The EXECUTE permission was denied on the object 'sqbmemory', database 'master', schema 'dbo'. Warning 300: Backup failed. Retry attempt: 4 VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. Check that the SQL Server instance is running, that you have the SQL Server System Administrator server role; and that no other processes are blocking the backup or restore process; or try increasing the value of the VDITimeout registry setting in HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\[InstanceName] SPID Status Login HostName BlkBy DBName Command CPUTime DiskIO LastBatch ProgramName SPID_1 REQUESTID ----- ------------------------------ -------------------------------------------------------- -------- ----- ------ ----------- ------- ------ -------------- ------------------ ------ --------- 53 RUNNABLE NT AUTHORITY\NETWORK SERVICE MICAH-PC . master SELECT INTO 47 0 02/21 11:32:20 SQBCoreService.exe 53 0 SQL error 3013: BACKUP DATABASE is terminating abnormally. SQL error 262: BACKUP DATABASE permission denied in database 'MyDatabase'. Failed to obtain memory status: SQL error 229: The EXECUTE permission was denied on the object 'sqbmemory', database 'master', schema 'dbo'. SQL Backup exit code: 1010 SQL error code: 262
Here's the trace from Sql Profiler
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED go SET NO_BROWSETABLE ON go SELECT status, DATABASEPROPERTYEX('MyDatabase', 'Status') DBStatus FROM master..sysdatabases WHERE name = 'MyDatabase' go SET NO_BROWSETABLE ON go BACKUP DATABASE [MyDatabase] TO VIRTUAL_DEVICE = 'SQLBACKUP_D29A02D9-D9AF-4720-BFE4-0C3237B7249C', VIRTUAL_DEVICE = 'SQLBACKUP_D29A02D9-D9AF-4720-BFE4-0C3237B7249C01', VIRTUAL_DEVICE = 'SQLBACKUP_D29A02D9-D9AF-4720-BFE4-0C3237B7249C02', VIRTUAL_DEVICE = 'SQLBACKUP_D29A02D9-D9AF-4720-BFE4-0C3237B7249C03', VIRTUAL_DEVICE = 'SQLBACKUP_D29A02D9-D9AF-4720-BFE4-0C3237B7249C04', VIRTUAL_DEVICE = 'SQLBACKUP_D29A02D9-D9AF-4720-BFE4-0C3237B7249C05', VIRTUAL_DEVICE = 'SQLBACKUP_D29A02D9-D9AF-4720-BFE4-0C3237B7249C06' WITH BUFFERCOUNT = 28, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (MyDatabase), 2/21/2012 11:30:12 AM', DESCRIPTION = N'Backup on 2/21/2012 11:30:12 AM Server: MICAH-PC Database: MyDatabase', FORMAT go exec master..sp_who2 go exec master..sqbmemory go SELECT status, DATABASEPROPERTYEX('MyDatabase', 'Status') DBStatus FROM master..sysdatabases WHERE name = 'MyDatabase' go BACKUP DATABASE [MyDatabase] TO VIRTUAL_DEVICE = 'SQLBACKUP_1908657D-1BF0-4D77-A33A-FFBC8A5EC6C4', VIRTUAL_DEVICE = 'SQLBACKUP_1908657D-1BF0-4D77-A33A-FFBC8A5EC6C401', VIRTUAL_DEVICE = 'SQLBACKUP_1908657D-1BF0-4D77-A33A-FFBC8A5EC6C402', VIRTUAL_DEVICE = 'SQLBACKUP_1908657D-1BF0-4D77-A33A-FFBC8A5EC6C403', VIRTUAL_DEVICE = 'SQLBACKUP_1908657D-1BF0-4D77-A33A-FFBC8A5EC6C404', VIRTUAL_DEVICE = 'SQLBACKUP_1908657D-1BF0-4D77-A33A-FFBC8A5EC6C405', VIRTUAL_DEVICE = 'SQLBACKUP_1908657D-1BF0-4D77-A33A-FFBC8A5EC6C406' WITH BUFFERCOUNT = 28, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 524288, NAME = N'Database (MyDatabase), 2/21/2012 11:30:12 AM', DESCRIPTION = N'Backup on 2/21/2012 11:30:12 AM Server: MICAH-PC Database: MyDatabase', FORMAT go exec master..sp_who2 go exec master..sqbmemory go SELECT status, DATABASEPROPERTYEX('MyDatabase', 'Status') DBStatus FROM master..sysdatabases WHERE name = 'MyDatabase' go BACKUP DATABASE [MyDatabase] TO VIRTUAL_DEVICE = 'SQLBACKUP_B6678507-B8AF-4C0C-AFFA-2465FCC14276', VIRTUAL_DEVICE = 'SQLBACKUP_B6678507-B8AF-4C0C-AFFA-2465FCC1427601', VIRTUAL_DEVICE = 'SQLBACKUP_B6678507-B8AF-4C0C-AFFA-2465FCC1427602', VIRTUAL_DEVICE = 'SQLBACKUP_B6678507-B8AF-4C0C-AFFA-2465FCC1427603', VIRTUAL_DEVICE = 'SQLBACKUP_B6678507-B8AF-4C0C-AFFA-2465FCC1427604', VIRTUAL_DEVICE = 'SQLBACKUP_B6678507-B8AF-4C0C-AFFA-2465FCC1427605', VIRTUAL_DEVICE = 'SQLBACKUP_B6678507-B8AF-4C0C-AFFA-2465FCC1427606' WITH BUFFERCOUNT = 28, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 262144, NAME = N'Database (MyDatabase), 2/21/2012 11:30:12 AM', DESCRIPTION = N'Backup on 2/21/2012 11:30:12 AM Server: MICAH-PC Database: MyDatabase', FORMAT go exec master..sp_who2 go exec master..sqbmemory go SELECT status, DATABASEPROPERTYEX('MyDatabase', 'Status') DBStatus FROM master..sysdatabases WHERE name = 'MyDatabase' go BACKUP DATABASE [MyDatabase] TO VIRTUAL_DEVICE = 'SQLBACKUP_1680B089-7191-41EA-A60D-83357E5A2D4C', VIRTUAL_DEVICE = 'SQLBACKUP_1680B089-7191-41EA-A60D-83357E5A2D4C01', VIRTUAL_DEVICE = 'SQLBACKUP_1680B089-7191-41EA-A60D-83357E5A2D4C02', VIRTUAL_DEVICE = 'SQLBACKUP_1680B089-7191-41EA-A60D-83357E5A2D4C03', VIRTUAL_DEVICE = 'SQLBACKUP_1680B089-7191-41EA-A60D-83357E5A2D4C04', VIRTUAL_DEVICE = 'SQLBACKUP_1680B089-7191-41EA-A60D-83357E5A2D4C05', VIRTUAL_DEVICE = 'SQLBACKUP_1680B089-7191-41EA-A60D-83357E5A2D4C06' WITH BUFFERCOUNT = 28, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 131072, NAME = N'Database (MyDatabase), 2/21/2012 11:30:12 AM', DESCRIPTION = N'Backup on 2/21/2012 11:30:12 AM Server: MICAH-PC Database: MyDatabase', FORMAT go exec master..sp_who2 go exec master..sqbmemory go SELECT status, DATABASEPROPERTYEX('MyDatabase', 'Status') DBStatus FROM master..sysdatabases WHERE name = 'MyDatabase' go BACKUP DATABASE [MyDatabase] TO VIRTUAL_DEVICE = 'SQLBACKUP_A90B05FA-3091-4309-9E4F-DD1636F4F450', VIRTUAL_DEVICE = 'SQLBACKUP_A90B05FA-3091-4309-9E4F-DD1636F4F45001', VIRTUAL_DEVICE = 'SQLBACKUP_A90B05FA-3091-4309-9E4F-DD1636F4F45002', VIRTUAL_DEVICE = 'SQLBACKUP_A90B05FA-3091-4309-9E4F-DD1636F4F45003', VIRTUAL_DEVICE = 'SQLBACKUP_A90B05FA-3091-4309-9E4F-DD1636F4F45004', VIRTUAL_DEVICE = 'SQLBACKUP_A90B05FA-3091-4309-9E4F-DD1636F4F45005', VIRTUAL_DEVICE = 'SQLBACKUP_A90B05FA-3091-4309-9E4F-DD1636F4F45006' WITH BUFFERCOUNT = 7, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 65536, NAME = N'Database (MyDatabase), 2/21/2012 11:30:12 AM', DESCRIPTION = N'Backup on 2/21/2012 11:30:12 AM Server: MICAH-PC Database: MyDatabase', FORMAT go exec master..sp_who2 go exec master..sqbmemory go
Comments
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
I had this same error. My fix was as follows:
Services.msc
"SQL Backup Agent" -> "Properties" -> "Log On" and set up the account to the proper service account defined within SSMS.
Stopped and then restarted the service.
Then it worked for me.