CURSO: SQL Server High Availability

Gain an in-depth look into SQL Server High Availability technologies and their usage

Developed in-house by SolidQ, the high Availability course provides an in-depth review of SQL Server High Availability, including concepts for HA, drill-through of the various technologies available with SQL Server, and how to implement high availability using those technologies. Troubleshooting and operational guidance will also be provided.



The course will take place in a classroom with no more than 20 students in order to maintain a good level of interactivity.


The course will take place in your companie’s facilities. We limit attendance to no more than 20 students in order to maintain a good level of interactivity. Request quote here!

“You’ve opened my eyes and helped me re-discover the passion I have for solving problems using creative and efficient methods”

Course Coverage

This course is designed for those responsible for designing and implementing high availability solutions for SQL Server 2014. 1 year of SQL Server experience and 1 year of Windows Server 2012 (or later) experience are needed. We also recommend 1 year of Hyper-V experience and 1 year of Windows Failover Clustering experience.


Design a SQL Server 2012 availability solution to meet their availability goals


Implement system maintenance while understanding the availability implications

Implement that design using the available technologies in SQL Server 2012


Troubleshoot problems with High Availability in SQL Server 2012


Module 01: High Availability Overview

  • Defining High Availability
  • Achieving High Availability

Module 02: Overview of Windosw Server Failover Clustering

  • Failover Clustering Concepts
  • Cluster Resources
  • Setting up a Windows Failover Cluster
  • MSDTC Clustering
  • LAB: Creating Your Windows Server Failover Cluster

Module 03: SQL Server High Availability Overview

  • SQL Server High Availability (HA) Technologies
  • High-level Considerations on Technology Choices
  • Common Combinations

Module 04: AlwaysOn Failover Clustering

  • SQL Server Failover Clustering – Definitions and History
  • SQL Server Failover Clustering Instance (FCI)
  • Maintaining a SQL Server FCI
  • Multi-Site Failover Clustering
  • MSDTC Clustering
  • LAB: Installing a Two-Node Failover Clustered SQL Server and Analysis Services Installation

Module 05: AlwaysON Availabilty Groups

  • Availability Group Concepts
  • Partners and Secondary Servers
  • LAB A: Creating an Availability Group Hosted on Three Servers: Primary, Synchronous Secondary, and Asynchronous Secondary
  • LAB B: Database Backups for Secondary Replicas: Creating Automated Database Backups on All Secondary Replicas

Module 06: Legacy Database Mirroring

  • Database Mirroring Overview
  • Database Mirroring Architecture
  • Enabling Database Mirroring
  • Database Mirroring Operations
  • LAB: Enabling Database Mirroring Between Two Servers

Module 07: Legacy Log Shipping

  • Log Shipping Overview
  • Log Shipping Architecture
  • Configuring Log Shipping
  • Log Shipping Internals
  • Administering Log Shipping
  • LAB: Enabling Log Shipping Between Two Servers

Module 08: Using Preplication for High Availability

  • Replication Overview
  • Replication Types
  • Replication Architecture
  • Configuring Replication
  • Replication Monitoring
  • LAB: Enabling Transactional Replication with Three Servers

Module 09: High Availabiltiy Solutions Interoperability

  • AlwaysOn Failover Cluster Instances with AlwaysOn Availability Groups
  • AlwaysOn Failover Cluster Instances with Legacy Database Mirroring
  • AlwaysOn Availability Groups with Replication
  • LAB: Creating AlwaysOn Availability Groups Running a Primary Replica on an AlwaysOn Failover Cluster Instance

Module 10: High Availability with Virtualization

  • Hyper-V in Windows Server 2012 R2
  • Improvements in Windows Server 2012/R2
  • SQL Server Hyper-V Support
  • Hyper-V HA Considerations
    • Using Cluster Shared Volumes for High Availability
    • Live Migration
    • Using Guest Clustering

Module 11: Meeting Your Availability Goals

  • Technology Choices
  • Servicing for Availability
  • Ongoing Maintenance
    • Indexing
    • Partitioning
  • Processes and Procedures for Availability
    • Rule No.1
    • Understanding the Technologies Used
    • Understanding the Procedures and Escalation Paths
    • Planned Downtime

Would you like to register for this course?

Fill out the form at the top of this page

Invite & Earn

Signup to start sharing your link