SQL Server 2008 R2: High Availability

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.

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
120 minutes

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.


Implementing Database Mirroring

  • 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

Implementing Log Shipping and Replication

  • 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

Implementing Failover Clustering

  • identify factors to consider when implementing failover clustering
  • recognize how to implement a failover cluster





Multi-license discounts available for Annual and Monthly subscriptions.