Course Duration
3 Days

Microsoft
Authorized Training

IT

Course cost:
was £3,499
£2,609

IT Certification Overview

Along the course you will learn the basics on how to create a high available solution, along with the potential threats the platform may face. You will learn how to install Windows Server 2019, maintain it, monitor and troubleshoot your solution.

Newto Training Reviews

What Our Happy Alumni Say About Us

Prerequisites

Experience administering a recent version of Microsoft SQL Server

Learning Objectives

  • Build a reliable High Availability solution with Windows Server 2019 and SQL Server 2019
  • Manage a High Availability solution with Windows Server 2019 and SQL Server 2019
  • Build Disaster Recovery Solutions
  • Troubleshoot problems with High Availability in SQL Server 2019

Building and Managing High Availability Solutions with SQL Server Course Content

Module 01: Introduction to High Availability

  • Basic aspects of High Availability

Module 02: Windows Server 2019 High Availability

  • Features Overview Overview of HA features in Windows Server 2019

Module 03: SQL Server 2019 High Availability Features Overview

  • Failover Cluster Instances
  • Availability Group
  • Log Shipping

Module 04: Windows Server 2019 Failover Clustering

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

Module 05: SQL Server 2019 Failover Clustering Instance

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

Module 06: SQL Server 2019 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

Module 07: SQL Server Interoperability

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

Building and Managing High Availability Solutions with SQL Server Dates

Next 2 available training dates for this course

OFFER!

VIRTUAL

QA On-Line Virtual Centre
3 DAYS | ALL DAY
Mon 23 Feb 2026
AVAILABLE
was £3,499
£2,609
BOOK NOW
OFFER!

VIRTUAL

QA On-Line Virtual Centre
3 DAYS | ALL DAY
Wed 03 Jun 2026
AVAILABLE
was £3,499
£2,609
BOOK NOW

Advance Your Career with Building and Managing High Availability Solutions with SQL Server

Gain the skills you need to succeed. Enrol in Building and Managing High Availability Solutions with SQL Server with Newto Training today.