You are the administrator of your company network. You are in charge of three SQL Server 2008 instances named Instance1, Instance2, and Instance3. Each of them runs on a separate server.
Between Instance1 and Instance2, a mission-critical database is mirrored. At present Instance1 currently acts as the Principal, while Instance3 acts as the witness. You intend to apply a patch on both servers. The server needs to restart itself. You have to identify the sequence of steps necessary to ensure that the patching process is completed with the minimum time and the database is online on the partner that currently does not apply the patch. Besides this two, you have to ensure that the database does not failover to the other partner during this time.So what should you do?
A.
You should apply the patch to the server which runs Instance2. Apply the patch to the server which runs Instance1.
B.
You should apply the patch to the server that runs Instance2. Manually failover the mirroring session. Apply the patch to the server that runs Instance1.
C.
You should 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 mirror
D.
You should suspend the mirroring session. Apply the patch to the server that runs Instance2.
Resume the mirroring session. Manually failover the mirroring. Apply the patch to the server that runs Instance1.