Building and Managing High Availability Solutions with SQL Server 2016 and 2014

Course Overview

This is a High-Availability course for the real-world. You’ll learn the essentials for buliding and managing a reliable high availability solution.

Who Should Attend

Those responsible for building and managing high availability solutions for SQL Server.

Course Objectives

Build a reliable High Availability solutionwith Windows Server 2012 R2/2016 and SQL Server 2014/2016 Manage a High Availability solution with Windows Server 2012 R2/2016 and SQL Server 2014/2016 Build Disaster Recovery Solutions Troubleshoot problems with High Availability in SQL Server 2016 and 2014

Suggested Prerequisites

Course Outline

1 - Introduction to High Availability

  • Basic aspects of High Availability

2 - Windows Server 2016 High Availability Features Overview

  • Overview of HA features in Windows Server 2016

3 - SQL Server 2016 High Availability Features Overview

  • Failover Cluster Instances
  • Availability Group
  • Log Shipping

4 - Windows Server 2016 Failover Clustering

  • Installation
  • Storage configuration
  • Quorum configuration
  • Maintenance
  • Patching/Upgrading
  • Adding/Removing nodes to/from cluster
  • Monitoring
  • Troubleshooting

5 - SQL Server 2016 Failover Clustering Instance

  • SQL Server FCI configuration
  • Active/Active
  • Active/Passive
  • MS DTC
  • Maintenance
  • Patching/Upgrading
  • o Adding/Removing SQL Server to/from cluster
  • Monitoring
  • Troubleshooting

6 - SQL Server 2016 Availability Groups

  • SQL Server AG configuration
  • Sync/Async
  • Read Only Routing and Load Balancing
  • Direct seeding
  • Distributed AG
  • Maintenance
  • Patching/Upgrading
  • Adding/Removing files to/from database in AG
  • Adding/Removing database to/from AG
  • Monitoring
  • Troubleshooting

7 - SQL Server Interoperability

  • Interoperability
  • with Integration Services
  • with Analysis Services
  • with Reporting Services

Enroll Today

This is a 3-day class

Price: $1,785.00
Payment Options

ILT Instructor‑Led Training


GTR  Guaranteed to Run

Class times are listed Central time. This class is available for Private Group Training

To sort by location or date, click the ‘When’ and ‘Where’ column headings.

Class dates not listed.
Please contact us for available
dates and times.