Backup Fails with Permission error on 'sqdmemory'

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Backup Fails with Permission error on 'sqdmemory'

Postby micahlmartin » Tue Feb 21, 2012 5:50 pm

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

Code: Select all
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


Code: Select all
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

micahlmartin
 
Posts: 1
Joined: Tue Feb 21, 2012 5:43 pm

Postby petey » Tue Feb 21, 2012 11:49 pm

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 7
petey
 
Posts: 2234
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests