VDI Error 1010
Backing up source database - Successful
This operation completed successfully.
Backing up HCN (full database) on HCNSYSTEM instance to:
Database size : 450.625 MB
Compressed data size: 143.883 MB
Compression rate : 68.07%
Processed 56496 pages for database 'HCN', file 'HCN' on file 1.
Processed 1 pages for database 'HCN', file 'HCN_log' on file 1.
BACKUP DATABASE successfully processed 56497 pages in 15.905 seconds (29.098 MB/sec).
SQL Backup process ended.
Restoring database to destination server - Failed
This operation failed with errors.
Restoring HCN (database) on HCNSYSTEM instance from:
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 and that you have the SQL Server System Administrator server role; or try increasing the value of the
VDITimeout registry setting in HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\[InstanceName]
Also check that the database is not currently in use.
SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 3101: Exclusive access could not be obtained because the database is in use.
SQL Backup exit code: 1010
SQL error code: 3101
Creating backup job - Pending
Create restore job - Pending
Refresh server information - Pending
I normally receive this following error when trying creating Logshipping between two servers. Sometime I am lucky and successfully creating Logshipping however after half of the day running fine, then I have the following error message above. This is the test server so I am pretty sure there is no user log in except me. And the job is running under sysadmin user.
The thing I would mention in here is sometimes restore database by either using full backup or log backup is fine, sometime is not. I changed to another set of servers and got the same issue.
Hope you guys can provide some more information