Question 22


Answers B, C, and F are correct. In setting up for mirroring, you set the full recovery mode instead of bulk-logged or simple. You restore a full backup by using NORECOVERY, allowing for more restores to occur. Mirroring endpoints are connection points used by independent instances of SQL Server.

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, Configuring High Availability, Database Mirroring, Overview of Database Mirroring"

  • "Managing Database Mirroring (SQL Server Management Studio)," http://msdn2.microsoft.com/en-us/library/ms175134.aspx

  • "Setting Up Database Mirroring," http://msdn2.microsoft.com/en-us/library/ms190941(SQL.90).aspx




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

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net