Microsoft
70-450 · Question #87
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:
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
(62 responses)- A5% (3)
- B6% (4)
- C74% (46)
- D15% (9)
Community Discussion
No community discussion yet for this question.