Unsolved
1 Rookie
•
9 Posts
0
1134
October 30th, 2019 11:00
avsql restore from a named instance backup fails
When I run an avsql redirected restore from a default instance, everything is fine. Running an avsql redirected restore from a named instance gives the [Error <14310>: Could not retrieve SQL metadata for the given database] error message. Best I can tell, when the avsql_assist is called to browse for the source database backup, it always tries to pull the default instance. How do I tell it to pull from a named instance? Here is my script...
avsql.exe --operation=restore --server=AvamarServer --path=/SQL_Servers/SourceServer --log=E:\SQLDBAdmin\Jobs\AvamarRestore_10012019.log --id=account --ap=***** --debug=true --app-instance=DestServer\SQL2016/ --restore-destination=multiple --dblocation=E:\SQLData\SQL2016 --altlog=samelocat "SourceServer\SQL2012/DBName"
Job Output...
avsql Info <5008>: Logging to E:\SQLDBAdmin\Jobs\AvamarRestore_DBAGroup_10012019.log
Dynamically allocated CTL listen port (50794)
avsql Info <6673>: CTL listening on port 50794
avsql Info <12592>: Sending adhoc request to the MCS
avsql Info <10684>: Setting ctl message version to 3 (from 1)
avsql Info <16136>: Setting ctl max message size to 268435456
avsql Info <17376>: Working on stand alone environment.
avsql Info <7838>: - Adding user exclude "*/tempdb"
avsql Error <14310>: Could not retrieve SQL metadata for the given database.
avsql Error <15760>: No targets after expansion!
avsql Error <15760>: No targets after expansion!
avsql Info <42977>: Final summary generated subwork 0, cancelled/aborted 0, promoted to full 0, snapview 0, exitcode 536870919
Terminating CTL listen thread
avsql Info <6451>: avsql returning with exitcode 536870919