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: yyyyyyCould not retrieve version from SQL Server--- End of SQLsafeCmd output ---
The event viewer has similar output: