Designing a Database Server High Availability Solution for SQL Server 2005


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


Overview/Description
To select the appropriate database storage design for a high availability scenario and identify a suitable replication solution

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)
1.8

Lesson Objectives

Designing a Database Server High Availability Solution for SQL Server 2005

  • determine the appropriate RAID solution to implement in a given SQL Server scenario.
  • identify how to implement a SAN solution for high availability in a given scenario.
  • determine the appropriate database storage solution for a high availability scenario.
  • select the appropriate replication solution for a scenario.
  • identify a strategy for implementing replication in a given scenario.
  • determine a database replication strategy for a specified scenario.

    • Course Number:
    236779_eng