Problem related to databases restore via RedGate :
While restoring database using Red Gate SQL Backup, was getting below error messages.
Error Msg:
4/20/2015 10:31:44 AM: Thread 3 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
4/20/2015 10:31:44 AM:
4/20/2015 10:31:45 AM: SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
4/20/2015 10:31:45 AM: SQL error 3117: SQL error 3117: The log or differential backup cannot be restored because no files are ready to rollforward.
Solution:
You could also try increasing SQL Backup's timeout value to 60 seconds, by adding/modifying the VDITimeout value in the registry (HKEY_LOCAL_MACHINE\\SOFTWARE\\Red Gate\\SQL Backup\\BackupSettingsGlobal\\[InstanceName]). The VDITimeout value is a DWORD type.
It worked perfectly fine for me so thought to share with you all.
Thanks
P.S: https://forums.red-gate.com/viewtopic.php?t=16174
While restoring database using Red Gate SQL Backup, was getting below error messages.
Error Msg:
4/20/2015 10:31:44 AM: Thread 3 error:
Process terminated unexpectedly. Error code: -2139684860 (An abort request is preventing anything except termination actions.)
4/20/2015 10:31:44 AM:
4/20/2015 10:31:45 AM: SQL error 3013: SQL error 3013: RESTORE DATABASE is terminating abnormally.
4/20/2015 10:31:45 AM: SQL error 3117: SQL error 3117: The log or differential backup cannot be restored because no files are ready to rollforward.
Solution:
You could also try increasing SQL Backup's timeout value to 60 seconds, by adding/modifying the VDITimeout value in the registry (HKEY_LOCAL_MACHINE\\SOFTWARE\\Red Gate\\SQL Backup\\BackupSettingsGlobal\\[InstanceName]). The VDITimeout value is a DWORD type.
It worked perfectly fine for me so thought to share with you all.
Thanks
P.S: https://forums.red-gate.com/viewtopic.php?t=16174
Warm Regards,
Chhavinath Mishra
Sr. Specialist Database Administrator
No comments:
Post a Comment