PrepAway - Latest Free Exam Questions & Answers

Which three actions should you perform?

Domain.com uses a mission-critical database named DB1, which is located on a server named SQL1. You want to mirror DB1 on a second server named SQL2. Before you can establish database mirroring, you need to prepare DB1 and the servers for mirroring. Which three actions should you perform? (Each correct answer presents part of the solution. Choose three.)

PrepAway - Latest Free Exam Questions & Answers

A.
Set the recovery model of DB1 on SQL1 to bulk-logged recovery.

B.
Set the recovery model of DB1 on SQL1 to full recovery.

C.
Back up DB1 on SQL1. Restore the backup on SQL2; specify the NORECOVERY option.

D.
Back up DB1 on SQL1. Restore the backup on SQL2; specify the STANDBY option.

E.
Back up DB1 on SQL1. Restore the backup on SQL2; specify the RECOVERY option.

F.
Create endpoints on all participating servers.

G.
Set the AutoShrink property of DB1 on SQL1 to false.

Explanation:
In order to configure mirroring you have to ensure that the databases are set to use the Full recovery model. Because database mirroring maintains both the primary and mirror databases as exact duplicates, including synchronizing all internal structures such as Log Sequence Numbers (LSNs), the Simple and Bulk-Logged recovery models are incompatible with database mirroring. When restoring the database to the mirror, it is essential that you specify the NORECOERY option for the RESTORE command, which guarantees that the starting state of the mirror reflects the state of the principal database, including the LSNs. Finally you have to produce a communication channel for the database mirroring to use and this is done by creating a endpoint for data mirroring on all participating servers.


Leave a Reply