Hi, my restore keeps failing after about 10 mins of trying to running.
The log file for the failure says:
VDI error 10 10: 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_MACHINESOFTWARERed GateSQL BackupBackupSettingsGlobal[InstanceName]
Also check that the database is not currently in use.
SQL error 30 13: RESTORE DATABASE is terminating abnormally.
SQL error 320 1: Cannot open badcup device 'SQLBACKUP_3E609150-44C9-4854-AFOA-ZBE58oF26A26'. Operating
system error ox80070002(The system not find the file specified.).
I increased the time out from 30 to 90 (mins?) and the file (as met by the wild card
M:sysliveperiodend*.sqb) exists.
The script is
DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [syslive] FROM DISK = ''M:sysliveperiodend*.sqb'' SOURCE = ''syslive'' LATEST_FULL WITH RECOVERY, DISCONNECT_EXISTING, REPLACE, ORPHAN_CHECK, CHECKDB = ''NO_INFOMSGS, ALL_ERRORMSGS''"', @exitcode OUT, @sqlerrorcode OUT
IF (@exitcode >= 500) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
END
Please help as this is starting to drive me psycho!
itsdanny.
Could you please post the contents of the SQL Backup log for the restore process that failed?
The log file for the failure says: I increased the time out from 30 to 90 (mins?) and the file (as met by the wild card M:sysliveperiodend*.sqb) exists.
The script is
DECLARE @exitcode int DECLARE @sqlerrorcode int EXECUTE master..sqlbackup '-SQL "RESTORE DATABASE [syslive] FROM DISK = ''M:sysliveperiodend*.sqb'' SOURCE = ''syslive'' LATEST_FULL WITH RECOVERY, DISCONNECT_EXISTING, REPLACE, ORPHAN_CHECK, CHECKDB = ''NO_INFOMSGS, ALL_ERRORMSGS''"', @exitcode OUT, @sqlerrorcode OUT IF (@exitcode >= 500) OR (@sqlerrorcode <> 0) BEGIN RAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode) ENDPlease help as this is starting to drive me psycho!
itsdanny.