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…

The correct answer is B. Restore with Norecovery. Prepare a secondary database for an Always On availability group requires two steps: 1. Restore a recent database backup of the primary database and subsequent log backups onto each server instance that hosts the secondary replica, using RESTORE WITH NORECOVERY 2. Join the…

Submitted by tarun92· Mar 6, 2026Plan and implement a HADR environment

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?

Options

ARestore with Recovery
BRestore with Norecovery
CRestore with Standby

How the community answered

(34 responses)

A
6% (2)
B
79% (27)
C
15% (5)

Explanation

Prepare a secondary database for an Always On availability group requires two steps: 1. Restore a recent database backup of the primary database and subsequent log backups onto each server instance that hosts the secondary replica, using RESTORE WITH NORECOVERY 2. Join the restored database to the availability group. https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/manually- prepare-a-secondary-database-for-an-availability-group-sql-server

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice