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 is configured as the
witness. Instance1 is configured as the Principal. You plan to apply an update to the servers
that run Instance1 and Instance2. The update requires a restart.
You need to ensure that the servers meet the following requirements during the update
process:
-Complete the update process in the least amount of time possible. -The database must be
available on one server during the update of another server. -The update process must not
cause an automatic failover of the database.
What should you do?
A.
Install the update on the server that runs Instance2. Perform a manual failover of the
mirroring session. Install the update on the server that runs Instance1.
B.
Remove the mirroring session. Install the update on both servers. Re-establish the
mirroring session.
C.
Remove the mirroring session. Run the SQL Server 2008 Upgrade Advisor Install the
update on both servers. Re-establish the mirroring session.
D.
Suspend the mirroring session Install the update on both servers.
E.
Suspend the mirroring session. Install the update on the server that runs Instance2.
Resume the mirroring session. Perform a manual failover of the mirroring session. Install the
update on the server that runs Instance1.