Posted by: Pdfprep
Post Date: December 1, 2020
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