ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-300 All Questions

View all questions & answers for the DP-300 exam
Go to Exam

Exam DP-300 topic 6 question 6 discussion

Actual exam question from Microsoft's DP-300
Question #: 6
Topic #: 6
[All DP-300 Questions]

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
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
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.
Reference:
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/manually-prepare-a-secondary-database-for-an-availability-group-sql-server
by themickou at Feb. 11, 2021, 1:49 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
themickou
Highly Voted 1 year, 8 months ago
correct, here an example generated wy the wizard USE [master] GO ALTER AVAILABILITY GROUP [AvailabilityGroup1] ADD DATABASE [Base3]; GO :Connect WIN-MSSQL2\INSTANCE1 BACKUP DATABASE [Base3] TO DISK = N'\\WIN-MSSQL2\AG-InitialBackup\Base3.bak' WITH COPY_ONLY, FORMAT, INIT, SKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 5 GO :Connect WIN-MSSQL3\INSTANCE2 RESTORE DATABASE [Base3] FROM DISK = N'\\WIN-MSSQL2\AG-InitialBackup\Base3.bak' WITH NORECOVERY, NOUNLOAD, STATS = 5 GO :Connect WIN-MSSQL2\INSTANCE1 BACKUP LOG [Base3] TO DISK = N'\\WIN-MSSQL2\AG-InitialBackup\Base3_20151015122656.trn' WITH NOFORMAT, NOINIT, NOSKIP, REWIND, NOUNLOAD, COMPRESSION, STATS = 5 GO :Connect WIN-MSSQL3\INSTANCE2 RESTORE LOG [Base3] FROM DISK = N'\\WIN-MSSQL2\AG-InitialBackup\Base3_20151015122656.trn' WITH NORECOVERY, NOUNLOAD, STATS = 5 GO GO
upvoted 14 times
...
Chunchi
Most Recent 9 months, 2 weeks ago
Selected Answer: B
B is correct answer
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago