You administer three SQL Server 2008 instances named Instance 1, Instance2, and
Instance3. Each of the three instances runs on a separate server. A mission-critical
database is mirrored between Instance 1 and Instance2. Instances acts as the witness.
Instance 1 currently acts as the Principal.
You plan to apply a patch to both servers. The patch requires a restart of the server.
You need to find out the sequence of steps necessary to ensure that the following
requirements are met:
-The patching process is completed in the shortest possible time. -The database is online on
the partner that currently does not apply the patch. -The database does not failover to the
other partner during this time.
What should you do?
A.
Apply the patch to the server that runs Instance2. Apply the patch to the server that runs
Instance1.
B.
Apply the patch to the server that runs Instance2. Manually failover the mirroring session.
Apply the patch to the server that runs Instance1.
C.
Remove the mirroring session. Apply the patch to the server that runs Instance2. Apply
the patch to the server that runs Instance1. Re-establish the mirroring session.
D.
Suspend the mirroring session. Apply the patch to the server that rims Instance2.
Resume the mirroring session. Manually failover the mirroring session. Apply the patch to
the server that runs Instance1.