Restores fail with 'memory status' issue

jimc5240

Hi,

All my restores are failing with the same problem. Below is one of the log files. Can somebody tell me where the problem might be? Thanks

SQL Backup log file 6.4.0.56

-SQL "RESTORE FILELISTONLY FROM DISK='E:\Production Databases\FULL_(local)_BugTracker_20100707_013009.sqb' WITH PASSWORD='XXXXXXXXXX' "

---

ERRORS AND WARNINGS

---

7/7/2010 1:45:59 PM: Reading filelist of "E:\Production Databases\FULL_(local)_BugTracker_20100707_013009.sqb"

7/7/2010 1:45:59 PM: RESTORE FILELISTONLY FROM VIRTUAL_DEVICE = 'SQLBACKUP_7AFA176A-3A7B-45E9-B41F-A66965420C49' WITH BUFFERCOUNT = 6, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576

7/7/2010 1:46:29 PM: 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]
7/7/2010 1:46:29 PM: SQL error 3013: RESTORE FILELIST is terminating abnormally.
7/7/2010 1:46:29 PM: SQL error 262: CREATE DATABASE permission denied in database 'master'.
7/7/2010 1:46:29 PM:
7/7/2010 1:46:29 PM: Failed to obtain memory status: SQL error 229: The EXECUTE permission was denied on the object 'sqbmemory', database 'master', schema 'dbo'.

7/7/2010 1:46:29 PM:

petey

>> 7/7/2010 1:46:29 PM: SQL error 262: CREATE DATABASE permission denied in database 'master'.

This is the cause of the problem. For some reason, SQL Backup has issued a CREATE DATABASE command, even though you have only requested to restore the file list from the backup file.

Could you please start Profiler, filter on the application name 'SQBCoreService.exe', and see what exactly is SQL Backup trying to do when it processes the RESTORE FILELISTONLY command?

Thanks.

neuracnu

I also had this exact issue while trying to restore a full backup on SQL Server 2008 R2. I ran SQL Profiler and got the following:

exec master..sqlbackup N'-SQL "RESTORE FILELISTONLY FROM DISK=''C:\Temp\FULL_(local)_fogbugz_20110221_003344.sqb''"'

This is where the process died. I tried running this in Enterprise Manager on the production machine and got the same error:

Msg 1, Level 15, State 1, Line 0
Reading filelist of "C:\Temp\FULL_(local)_fogbugz_20110221_003344.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]
SQL error 3013: RESTORE FILELIST is terminating abnormally.
SQL error 262: CREATE DATABASE permission denied in database 'master'.

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

This turned out being a permissions bug. I had set up the server to run as NT AUTHORITY\NETWORK SERVICE but, for some reason, that login was not added to the sysadmin server role. To fix it, I used Enterprise Manager to browse to my server > Security > Server Roles > sysadmin and added NT AUTHORITY\NETWORK SERVICE as a role member. That fixed it.

petey

Thanks for posting your experience. This should help other users facing the same issue.