Question 39

Answers A and D are correct. To achieve automatic failover of a mirrored database set, you must have the mirror configured for synchronous delivery, and you also need to have a witness configured. The witness actually identifies the state in which the failover is triggered.

For more information, see the following sources:

  • Chapter 9, "Implementing High Availability"

  • SQL Server 2005 Books Online: "SQL Server Database Engine, Administering the Database Engine, Database Mirroring, Database Mirroring Sessions, Role Switching During a Database Mirroring Session, Automatic Failover"

MCTS 70-431(c) Implementing and Maintaining Microsoft SQL Server 2005
MCTS 70-431 Exam Cram: Implementing and Maintaining Microsoft SQL Server 2005 Exam
ISBN: 0789735881
EAN: 2147483647
Year: 2006
Pages: 200
Authors: Thomas Moore

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: