In part five of the Azure SQL Virtual Machine Reimagined series, we will a do deep dive of HA & DR technologies for Azure SQL VMs. We'll cover how to simplify HA & DR configuration by adopting multi subnet approach and thus eliminating the need for an Azure Load Balancer. Multi subnet congratulation is natively supported by SQL Server and Windows Server Failover Cluster and simplifies deployment, maintenance and improves failover time.
Resources:
SQL Server on Azure VM documentation: https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/
Azure SQL Virtual Machine Reimagined Series playlist: https://aka.ms/azuresqlvmyt
Wednesday, October 27, 2021
Azure SQL Virtual Machines Reimaged: Simplify HA & DR configuration (Ep.5) | Data Exposed Live
