SQL Server 2008 High Availability and Disaster Recovery

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

Overview

SQL Server 2008 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 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 or two to three years of experience using a previous version of SQL Server

Expected Duration

120 min.

Course Objectives

Introduction to Database Mirroring in SQL Server 2008

  • identify the features of database mirroring
  • recognize the functionality of database mirroring
  • Database Mirroring Configuration in SQL Server 2008

  • identify the requirements and recommendations for setting up a new database mirroring session with SQL Server 2008
  • recognize how to configure database mirroring
  • SQL Server 2008 Log Shipping Configuration

  • identify the features of log shipping
  • recognize how to configure log shipping
  • recognize how to monitor log shipping
  • Replication Configuration in SQL Server 2008

  • identify the features of data replication in SQL Server
  • recognize how to configure data replication
  • Replication Management in SQL Server 2008

  • recognize the factors that affect data replication performance in SQL Server
  • recognize how to manage data replication in SQL Server 2008
  • High-Availability Solutions in SQL Server 2008

    Failover Clustering in SQL Server 2008

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



     

    NEED HELP OR NOT SURE?