Designing a Database Failover Solution for SQL Server 2005


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


Overview/Description
To identify the appropriate cluster configuration solution, database mirroring solution, and log shipping solution for a 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 Failover Solution for SQL Server 2005

  • identify the considerations involved in designing a Microsoft cluster service.
  • recognize how to install failover clustering for SQL Server 2005.
  • determine the appropriate cluster configuration to implement, given a scenario.
  • recognize how server role switching works in database mirroring.
  • recognize the considerations involved in designing a database mirroring strategy.
  • determine a database mirroring solution for a given scenario.
  • identify the considerations involved in designing a log shipping strategy.
  • determine the appropriate log shipping solution for a given scenario.

    • Course Number:
    236789_eng