Load-based multiple restore errors?
I'm currently running 126.96.36.199, and I have a very annoying issue.
Every week I have a series of six DB backups that need to be restored to the same reporting/snapshot machine. All the backup files are on the same (but different from the target) networked machine.
SQL Backup allows up to four restores to be running at one. However, I often get the following problems when I try to get them running at once.
1/26/2014 9:03:04 AM: 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]
1/26/2014 9:03:04 AM: Also check that the database is not currently in use.
(I've done all the suggested VDITimeout solutions, but none of them work because, I think, of the later errors)
1/26/2014 9:05:27 AM: SQL error 3013: RESTORE DATABASE is terminating abnormally.
1/26/2014 9:05:27 AM: SQL error 3201: Cannot open backup device 'SQLBACKUP_7C19257A-80B8-4857-AE48-AFF278BDE9C3'. Operating system error 0x80070002(The system cannot find the file specified.).
Now, I'm not entirely sure what that final error means. Does it mean that the OS on the machine holding the backup file is reporting an error message? Does it mean the DB Server OS is reporting some issue with a virtual file? Because the file does exist. If I simply wait until one or more of the running restores are completed and then retry the restore, it works fine.
Any idea what might be causing this?
The databases in question are roughly 500GB in size.