PrepAway - Latest Free Exam Questions & Answers

You need to ensure that automatic failover is disabled during the maintenance process

You administer three SQL Server 2008 instances on separate servers named Server1,
Server2, and Server3.
The AdventureWorks database is configured for mirroring between the instances. In the
mirroring session, Server1 and Server2 act as partners and Server3 as the witness.
You have the following requirements:
-All three servers run a maintenance process that requires occasional restart of the
computer. -The SQL Server service on each server is shut down only during the actual
restart of the computer.
-After completion of the maintenance process, re-enable automatic failover and synchronize
the mirroring session in minimum possible time.
You need to ensure that automatic failover is disabled during the maintenance process.
What should you do first?

PrepAway - Latest Free Exam Questions & Answers

A.
Suspend the mirroring session.

B.
Remove mirroring from the database.

C.
Configure the mirroring session with the SAFETY option set to ON.

D.
Remove the witness server from the mirroring session.


Leave a Reply