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. [v184.108.40.206]SQLsafeCmd output:------------------SQLsafe Backup and Recovery CLI Version 220.127.116.11 (x64)Copyright (c) 2004-2014 Idera, Inc., All Rights Reserved.<http://www.idera.com/>Connecting to service on XXXXXXX ...success. (18.104.22.168)RESTORE yyyyyy...FAILED.Server instance: XXXXXXX , Database: yyyyyyCould not retrieve version from SQL Server--- End of SQLsafeCmd output ---
The event viewer has similar output:
Powered by IDERA