Chapter 3: Optimizing and Implementing a Data Recovery Plan for a Database


Microsoft Exam Objectives Covered in this Chapter:

  • image from book Diagnose causes of failures. Failure types include database failures, physical server failures, and SQL Server service failures.

  • image from book Plan for fault-tolerance.

  • image from book Recover from a failure of SQL Server 2005.

  • image from book Recover from a database disaster.

    • Plan a strategy.

    • Restore a database.

    • Configure logins.

    • Recover lost data.

    • Maintain server and database scripts for recoverability.

  • image from book Salvage good data from a damaged database by using restoration techniques.

One of the key responsibilities of a database administrator (DBA) is to design and implement an appropriate data recovery plan for a SQL Server 2005 database solution. Designing an appropriate data recovery plan involves more than just designing an appropriate database backup strategy. This chapter will examine the other important facets that apply. As always, it is important to analyze what you are protecting against, so don’t forget to include the possibility of accidental or malicious data modification in your data recovery plan.



MCITP Administrator. Microsoft SQL Server 2005 Optimization and Maintenance Study Guide (70-444)
MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
ISBN: 0470127457
EAN: 2147483647
Year: 2004
Pages: 146

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