Microsoft SQL Server 2012: Configuring High Availability


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
SQL Server 2012 provides several key features that improve the availability of servers and databases so that downtime for users is minimized. These solutions include AlwaysOn Failover Clustering, AlwaysOn Availability Groups, database mirroring, and Replication. 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 SQL Server 2012's AlwaysOn features, database mirroring, and replication to ensure that SQL Server 20012 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 the Microsoft SQL Server 2012 exam 70-462: Administering Microsoft SQL Server 2012 Databases. This exam is one of the requirements for the Microsoft Certified Solutions Associated (MCSA): SQL Server 2012 certification.

Target Audience
Professionals typically pursuing a career as a Database Administrator; individuals who do not 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 among others; Database Administrators who as part of their daily task perform installation, maintenance, and configuration tasks

Expected Duration (hours)
2.0

Lesson Objectives

Microsoft SQL Server 2012: Configuring High Availability

  • match the high availability solutions to their descriptions
  • describe the considerations involved in installing SQL Server AlwaysOn Failover Clustering
  • match the steps in the failover process with appropriate examples
  • describe the considerations involved in implementing AlwaysOn Availability Groups
  • implement AlwaysOn Availability Groups
  • prepare for database mirroring
  • describe how to set up database mirroring
  • describe how to monitor database mirroring sessions
  • describe the options when setting up replication
  • match the subscription types to their description
  • determine the most appropriate high availability solution for a given scenario
  • recognize the considerations involved in implementing AlwaysOn Availability Groups and SQL Server Failover Clustering
  • implement database mirroring
  • recognize how to distribute data and database objects using replication
  • Course Number:
    md_msdb_a09_it_enus

    Expertise Level
    Intermediate