Optimizing a Database Data Recovery Plan for SQL Server 2005


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
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

Prerequisites
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 (hours)
2.0

Lesson 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.

    • Course Number:
    237864_eng