What are the challenges you face when working across database platforms? Take the survey
Options

Backup Fails with Permission error on 'sqdmemory'

micahlmartinmicahlmartin 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
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

  • Options
    peteypetey Posts: 2,358 New member
    SQL Backup runs via a Windows service, named SQL Backup Agent. Does the user account used to start the SQL Backup Agent service have SQL Server sysadmin rights assigned to it?
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    With the understanding this error could vary depending on your system setup.

    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.
Sign In or Register to comment.