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?
A.
Configure the mirroring session with the SAFETY option set to OFF and the WITNESS
option set to OFF.
B.
Configure the mirroring session with the SAFETY option set to FULL and the WITNESS
option set to OFF.
C.
Configure the mirroring session to add a witness.
D.
Configure the mirroring session for high-safety mode with automatic failover.