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]
SQLsafe Backup and Recovery CLI Version 220.127.116.11 (x64)
Copyright (c) 2004-2014 Idera, Inc., All Rights Reserved.
Connecting to service on XXXXXXX …success. (18.104.22.168)
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 22.214.171.124: 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|