Question 23


Answers B, C, and F are correct. Log shipping is the process of sending regular backups of logs to be restored on a second instance. To be able to back up logs, you must get the database out of a simple recovery mode. The standby option is used to have the destination server be set up as a read-only 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, Log Shipping, Configuring Log Shipping:

  • "How to Configure the Destination System for Log Shipping," http://msdn.microsoft.com/library/default.asp?url=/library/en-us/bts06operations/html/7b4425f5-b105-4fb2-a503-94ca1e75ad55.asp




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

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