Everything you always wanted to know about HA/DR for SQL Server on Azure VMs but were afraid to ask
summary
Survey of HA/DR for SQL Server on Azure VMs that names concrete choices and tradeoffs: backups go to Azure Blob and automated backups via SQL IaaS agent extension are free; log shipping uses blobs but needs full recovery; Azure shared disks enable failover cluster instances; Always On Availability Groups are recommended for read-scale and low RPO/RTO; >100 databases or extreme transaction rates favor FCI due to worker‑thread limits; availability sets give ~99.95% while zones give ~99.99%; portal wizard builds AGs in ~35–45 minutes.
AI-written summary · about
chapters (9)
- 0:00Introduction and speaker intro
- 1:31HA/DR basics explained
- 9:22SQL Server HA/DR features overview
- 15:12Azure backup and log shipping
- 22:19Availability sets and zones
- 28:54Choosing HA/DR features
- 34:08Scenario-based recommendations
- 43:32Azure portal HA setup demo
- 49:16Q&A and closing
related talks
52mHADR on SQL Server on Azure VMs: Everything you Need to Know
54mDesigning Azure Data Disaster Recovery Strategies
52mMicrosoft SQL Server HA/DR on AWS
50mSQL Server to Azure SQL: Performance and Availability
47mPerfecting business continuity for Azure SQL DB
47mDisaster Recovery Strategies for SQL Server
46mBusiness continuity of on-prem SQL Servers using Azure services through Arc
46mAzure SQL Database Business Continuity During Disaster