I recently inherited a system which uses the backups of a production system to populate a test environment for devs. They do a refresh every few months, and when they tried it a couple days ago, it failed. I am not able to tell from the error message "Could not retrieve version from SQL Server" what is actually failing.
xp_ss_restore did not complete. An error(0,1) was encountered. Please check the parameters and their values. [v7.4.0.86]
SQLsafeCmd output:
——————
SQLsafe Backup and Recovery CLI Version 7.4.0.86 (x64)
Copyright (c) 2004-2014 Idera, Inc., All Rights Reserved.
<http://www.idera.com/>
Connecting to service on XXXXXXX …success. (7.4.0.86)
RESTORE yyyyyy…FAILED.
Server instance: XXXXXXX , Database: yyyyyy
Could not retrieve version from SQL Server
— End of SQLsafeCmd output —
The event viewer has similar output:
SQLsafe Backup Service version 7.4.0.86: Restore of database yyyyyy failed at 2/24/2022 3:16:09 PM due to Server instance: XXXXXX, Database: yyyyyy. Could not retrieve version from SQL Server |