Additional steps required after restoring SQL AG databases
You must perform the following steps after restoring a SQL Availability Group (AG) database:
Note:
If you are restoring the AG database to multiple replicas, perform the entire restore process on the primary replica first, and then repeat the steps for each secondary replica.
Add the restored database to the AG on the primary replica.
From the SQL Server Management Studio, right-click on the AG entry and select . In the wizard workflow, select the database, and on the Initial Data Synchronisation page, select the option. You can select the other options depending on the requirement.
If you restoring the same database to a secondary replica, perform the following steps:
Restore database to the secondary SQL instance in "Not recovered" state. Restore with no recovery should be successful.
Join the database to the AG on the secondary replica.
From the SQL Server Management Studio, connect to the secondary replica node, then right-click on the database and select .
Observe that the database status on the secondary replica change from
(Restoring...)to(Synchronized), indicating that AG database snapshot restore is successful.
You must repeat these steps for each replica where you wish to restore an AG database.