Dive deep into High Availability (HA) and Disaster Recovery (DR) technologies for Azure SQL Virtual Machines in this comprehensive live session. Explore how to simplify HA & DR configuration using a multi-subnet approach, eliminating the need for an Azure Load Balancer. Learn about the native support for multi-subnet configuration in SQL Server and Windows Server Failover Cluster, and discover how it streamlines deployment, maintenance, and improves failover time. Watch demonstrations on secondary IP configuration, Windows cluster setup, Availability Group resources, and Zone Redundant Shared disk implementation. Compare various HA DR configurations and gain insights from expert speakers on best practices for Azure SQL VM management.
Azure SQL Virtual Machines - Simplifying HA and DR Configuration - Episode 5
Overview
Syllabus
Stream begins.
Introductions.
SQL VM HA & DR Overview.
Simplify HR & DR configuration.
Demo: Secondary IP, Add Secondary IP.
Multi subnet configuration - steps involved.
Demo: Windows cluster, AG resources in cluster, AG & AG Listener in SSMS, Test connectivity from client, Test failover, Test connectivity from client.
Demo: Zone Redundant Shared disk​, Windows cluster​, SQL FCI resources in cluster​, Test connectivity from client​, Failover in cluster​, Test connectivity from client​.
Comparing available HA DR configurations.
Taught by
Microsoft Developer
