Microsoft
70-432 · Question #218
You manage two SQL Server 2008 instances on separate servers named Server1 and Server2. The servers are located in different cities. You plan to implement database mirroring between the two…
The correct answer is A. Configure the mirroring session with the SAFETY option set to OFF and the WITNESS. See the full explanation below for the reasoning.
Question
You manage two SQL Server 2008 instances on separate servers named Server1 and Server2. The servers are located in different cities. You plan to implement database mirroring between the two instances. You need to set up the mirroring session to support the high volume of write transactions to the database. You do not want small errors to impact the principal server. What should you do?
Options
- AConfigure the mirroring session with the SAFETY option set to OFF and the WITNESS
- BConfigure the mirroring session with the SAFETY option set to FULL and the WITNESS
- CConfigure the mirroring session to add a witness.
- DConfigure the mirroring session for high-safety mode with automatic failover.
How the community answered
(48 responses)- A77% (37)
- B15% (7)
- C2% (1)
- D6% (3)
Community Discussion
No community discussion yet for this question.