Designing a Database Server Data Recovery Solution for SQL Server 2005


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


Overview/Description
To select the appropriate data backup and recovery solution for a SQL Server 2005 database

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

Lesson Objectives

Designing a Database Server Data Recovery Solution for SQL Server 2005

  • identify the data recovery requirements of a given business scenario and determine the appropriate recovery model to use.
  • identify considerations for designing an appropriate backup strategy for a given database scenario.
  • identify database backup considerations.
  • determine the appropriate backup strategy for a database scenario.
  • identify considerations for designing a disaster recovery plan.
  • identify the appropriate restore strategy for a given database scenario.
  • determine a recovery strategy for a given database scenario.

    • Course Number:
    236970_eng