70-432 · Question #224
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…
The correct answer is C. Configure the mirroring session with the SAFETY option set to ON. See the full explanation below for the reasoning.
Question
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?
Options
- ASuspend the mirroring session.
- BRemove mirroring from the database.
- CConfigure the mirroring session with the SAFETY option set to ON.
- DRemove the witness server from the mirroring session.
How the community answered
(27 responses)- A4% (1)
- B7% (2)
- C85% (23)
- D4% (1)
Community Discussion
No community discussion yet for this question.