Restoring a SQL Server availability database to a secondary replica
This procedure describes how to restore a SQL Server availability database to a secondary replica. Follow this procedure if a secondary replica is unavailable for an extended time and needs to be synchronized with the primary. Or follow these instructions after you add a new secondary replica to the availability group.
To restore any system databases or user databases in the backup, perform a separate browse and restore operation using the replica name.
To restore a SQL Server availability database to a secondary replica
- Log on to the node that hosts the secondary replica.
- Close any connections to the database on the secondary replica.
- Remove the secondary database from the availability group.
- In the NetBackup MS SQL Client, select File > Set SQL Server connection properties.
- From the Instance list, select the instance that hosts the availability group.
- Browse for the backup images you want to restore. Select the latest full backup image and transaction log backups.
- Select the following settings:
From the Recovery list, select Not recovered.
Select Use replace option.
- If the replicas in the availability group use different paths for the database file, you need to create a move template to restore to a secondary replica. From the Scripting list, choose Create a move template.
- Click Restore.
- When the restore completes, join the database to the availability group.
More Information