SQL Server 2005 High Availability and Disaster Recovery


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



Overview/Description
To implement database mirroring, log shipping, database snapshots, and data replication in SQL Server 2005

Target Audience
Professionals typically pursuing a career as a Database Administrator, Database Developer or Business Intelligence Developer; individuals who do not work with SQL Server as a part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators among others

Prerequisites
This is a high-level technical path and candidates for the exam, and hence learners should be expert in the following areas: Tools usage UI navigation Wizards usage Writing code in the appropriate language (Transact-SQL, CLR Language, other scripting languages, etc.) Code debugging or syntactic issue resolution Troubleshooting Accomplishing specific focused tasks through the use of code or UI navigation

Expected Duration (hours)
3.0

Lesson Objectives

SQL Server 2005 High Availability and Disaster Recovery

  • recognize the features and functionality of database mirroring.
  • configure database mirroring in a given scenario.
  • configure database mirroring in SQL Server 2005.
  • configure and monitor log shipping in a given scenario.
  • configure log shipping options in SQL Server 2005.
  • configure database snapshots in a given scenario.
  • configure data replication in a given scenario.
  • manage replication in SQL Server 2005, given a scenario.
  • set up data replication in SQL Server 2005.
  • Course Number:
    234771_eng