Steps required before restoring SQL AG databases
You must perform the following steps before you restore 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.
For the database that you want to restore, suspend data movement from the replica.
From the SQL Server Management Studio, right-click on the database and select .
Remove the database from the AG on the replica.
From the SQL Server Management Studio, right-click on the database and select .
Confirm that the database is no longer part of the AG. Observe that the database on the primary replica is no longer in synchronized mode, and the status of the corresponding database on the secondary replica appears as
(Restoring...).Delete the database from the replica.
From the SQL Server Management Studio, right-click on the database and select .