Designing a Database Failover Solution for SQL Server 2005

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

Overview

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

140 min.

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

 

SUBSCRIPTION COST



 

NEED HELP OR NOT SURE?