Activity overview
Latest activity by 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. / comments
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:...