Red Gate forums :: View topic - Backup Fails with Permission error on 'sqdmemory'
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

Backup Fails with Permission error on 'sqdmemory'

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
micahlmartin



Joined: 21 Feb 2012
Posts: 1

PostPosted: Tue Feb 21, 2012 5:50 pm    Post subject: Backup Fails with Permission error on 'sqdmemory' Reply with quote

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:

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:

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

Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2301

PostPosted: Tue Feb 21, 2012 11:49 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group