AppSync can restore a database from a copy that is taken from the primary or secondary replica. These general guidelines apply:
- The database being restored must be removed from the availability group before it is restored. AppSync does it automatically, however, it must be added back to the availability group, once the recovery is complete.
- Usually, while the primary replica is restored, the secondary replica must be re-seeded.
- If restoring to a secondary replica, which is to be re-seeded to the other replicas, first use the option to fail over the primary replica. Once recovery is complete, use the restored replica to reseed the other database replicas.
- AppSync restores to the server (or SQL Server virtual server) that was used to create the copy.
- Restores are at the volume level, so all databases on the volume are impacted.
- If the databases were protected together, an option is presented for restoring and recovering the other databases.
- If the databases were not protected together, the other databases are overwritten, but not recovered. Detaching them from SQL Server before running the restore is required.