DP-300 Certification Practice Question #215

Question

You have SQL Server on Azure virtual machines in an availability group.
You have a database named DB1 that is NOT in the availability group.
You create a full database backup of DB1.
You need to add DB1 to the availability group.
Which restore option should you use on the secondary replica?

Accepted Answer

To manually prepare a database to join a SQL Server Always On Availability Group on a secondary replica, the database backups must be restored using the **RESTORE WITH NORECOVERY** option. This option leaves the restored database in a non-operational, restoring state, which allows the database to remain in sync with the primary replica and accept subsequent transaction log backups. If the database is restored with recovery (option A), it becomes fully online and active, which changes the recovery fork and prevents it from participating in the Availability Group replication.

More DP-300 practice questions