Which restore option should you use on the secondary replica?

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?
A . Restore with Recovery
B. Restore with Norecovery
C. Restore with Standby

View Answer

Answer: B

Explanation:

Prepare a secondary database for an Always On availability group requires two steps: