GJones1
1 Copper

avsql restore from a named instance backup fails

avsql restore from a named instance fails with Error <14310>: Could not retrieve SQL metadata for the given database.

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

Reply