Which restore option should you use on the secondary replica?

Posted by: Pdfprep Category: DP-300 Tags: , ,

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

Answer: B

Explanation:

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

Leave a Reply

Your email address will not be published.