IBM Support

How to restore an AlwaysOn Availability database using the Command-Line

Question & Answer


Question

How can a database in a SQL Server 2012 AlwaysOn Availability Group environment be restored from the Command-Line Interface (CLI)?

Cause

For a database in a SQL Server 2012 AlwaysOn Availability Group environment the restore issued by command:
>tdpsqlc restore <database name> full /sqlserver=<local SQL Server name> /object=<backup object name>

failed with error:
ACO5551I There are no backups matching the criteria specified for server name <local SQL Server name>

Answer

For restore of a database in a SQL Server 2012 AlwaysOn Availability Group environment following has to be specified:

- the AlwaysOn Availability Group name as SQL Server name

- the option /QUERYNode to indicate to the TSM Server that the backup object is managed by the ALWAYSONNode name.

The restore command has to be issued similar to:


>tdpsqlc restore <database name> full /sqlserver=<AlwaysOn Availability Group name> /QUERYNODE=ALWAYSON /object=<backup object name>

[{"Product":{"code":"SSTFZR","label":"Tivoli Storage Manager for Databases"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Data Protection for MS SQL","Platform":[{"code":"PF033","label":"Windows"}],"Version":"7.1","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
17 June 2018

UID

swg21979092

Page Feedback