SQL Server 2008 R2: High Availability

Overview/Description
SQL Server 2008 R2 provides several key features that improve the availability of servers and databases so that downtime for users is minimized. These solutions include database mirroring, log shipping, replication, and failover clusters. These reliability features help administrators maintain multiple sets of data that help ensure that critical systems remain accessible, and can be fully recovered in the event of a disaster. This course addresses how to configure database mirroring, log shipping, replication, and failover clusters to ensure that SQL Server 2008 R2 environments are available to users at all times by providing a high-availability and complete disaster-recovery solution. This course is one of a series in the SkillSoft learning path that covers the objectives for Microsoft SQL Server 2008 exam number 70-432. Passing this exam will earn the learner the Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance certification.

Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who don't work directly with SQL Server as part of their primary job but wish to show their breadth of technology experience, including developers and systems administrators.

Prerequisites
One to two years of experience using SQL Server 2008, SQL Server 2008 R2, or two to three years of experience using a previous version of SQL Server

Expected Duration (hours)
2.0

Lesson Objectives

SQL Server 2008 R2: High Availability

identify the features of database mirroring

recognize the functionality of database mirroring

identify the requirements and recommendations for setting up a new database mirroring session with SQL Server 2008 R2

recognize how to configure database mirroring

identify the features of log shipping

recognize how to configure log shipping

recognize how to monitor log shipping

identify the features of data replication in SQL Server

recognize how to configure data replication

recognize the factors that affect data replication performance in SQL Server

recognize how to manage data replication in SQL Server 2008 R2

configure and monitor database mirroring in a given scenario

configure log shipping in a given scenario

configure data replication in a given scenario

identify factors to consider when implementing failover clustering

recognize how to implement a failover cluster