QUESTION 3:
You administer three SQL Server 2008 instances named Instance1, Instance2, and Instance3.Each of the three instances runs on a separate server.A mission-critical database is mirrored between Instance1
and Instance2.Instance3 acts as the witness.Instance1 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.Suspend the mirroring session.
Apply the patch to the server that runs Instance2.
Resume the mirroring session.
Manually failover the mirroring session.
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.Apply the patch to the server that runs Instance2.
Apply the patch to the server that runs Instance1.
Answer: A
No comments:
Post a Comment
Note: only a member of this blog may post a comment.