HP 3PAR Recovery Manager Software for Microsoft SQL Server Licenses User Manual
Page 84
secondary databases will be in restoring state. All secondary databases must be restored manually
after the restore operation is completed on primary node by HP 3PAR Recovery Manager for SQL.
To manually restore availability database on secondary replica node:
1.
Take Full backup of the availability database and transaction log at primary replica node.
2.
Manually restore the secondary availability database and its log from the backup taken at
primary replica node using RESTORE WITH NO RECOVERY option. If the primary database
and secondary database have different file paths, you must use the WITH MOVE option.
3.
Perform this restore sequence on every server instance that hosts a secondary replica for the
availability group.
4.
Join the database to the Availability group.
84
Recovery for Microsoft SQL Server