Wikibooks

Microsoft Certified IT Professional/Exam 70-444/Optimizing and Implementing a Data Recovery Plan for a Database

< Microsoft Certified IT Professional‎ | Exam 70-444

Optimizing and Implementing a Data Recovery Plan for a Database

  • Diagnose causes of failures. Failure types include database failures, physical server failures, and SQL Server service failures.
  • Plan for fault-tolerance.
  • Recover from a failure of SQL Server 2005.
  • Recover from a database disaster.
    • Plan a strategy.
    • Restore a database.
    • Configure logins.
    • Recover lost data.
    • Maintain server and database scripts for recoverability.
    • Salvage good data from a damaged database by using restoration techniques.
Retrieved from "https://en.wikibooks.org/w/index.php?title=Microsoft_Certified_IT_Professional/Exam_70-444/Optimizing_and_Implementing_a_Data_Recovery_Plan_for_a_Database&oldid=3332840"