Optimizing a Database Data Recovery Plan for SQL Server 2005

This course is included in our On-demand training solution.


To identify potential causes of database failure, and select the appropriate fault tolerance and restore strategies for a scenario

Target Audience

Professionals pursuing a career as a Database Administrator


Candidates for the MCITP: Database Administrator certification should have taken and passed exam 70-431 to be certified as an MCTS: SQL Server 2005.

Expected Duration

120 min.

Course Objectives

Optimizing a Database Data Recovery Plan for SQL Server 2005

  • identify and troubleshoot the causes of database failure in a given scenario.
  • recognize how to install failover clustering for high availability and fault tolerance.
  • recognize how to set up database mirroring for fault tolerance, given a scenario.
  • determine and configure the appropriate fault tolerance plan for a scenario.
  • identify considerations for recovering from a database disaster in a given scenario.
  • identify and implement the appropriate restore strategy to recover a database in a given scenario.
  • determine how best to recover data following a given database disaster scenario.