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