Microsoft SQL Server HA/DR on AWS
summary
Clear checklist of what actually works: compares RDS multi‑AZ single‑checkbox managed HA versus self‑managed SQL Server on EC2, and details EBS snapshots, VSS‑enabled crash‑consistent snapshots, AWS Systems Manager/State Manager, AWS Backup, FSx for Windows, CloudEndure, log shipping, FCI and Availability Groups. Gives numbers: device mirroring failover ~1–2 minutes, Always On AG failover under 10 seconds. Shows DR patterns (multi‑AZ, multi‑region, distributed AG), and a concrete cost trick: spin up read/reporting instances from snapshots to avoid idle license fees.
AI-written summary · about
chapters (8)
- 0:00SQL Server on AWS intro
- 6:49High availability and disaster recovery overview
- 24:51Failover cluster instances
- 31:30DR beyond single region
- 42:13Availability groups vs FCI
- 44:41RDS HA/DR options
- 49:12Licensing costs optimization
- 51:19Summary
related talks
49mEverything you always wanted to know about HA/DR for SQL Server on Azure VMs but were afraid to ask
47mPerfecting business continuity for Azure SQL DB
20mFlying High with Highly Available SQL Server Deployments
52mHADR on SQL Server on Azure VMs: Everything you Need to Know
54mDesigning Azure Data Disaster Recovery Strategies
47mDisaster Recovery Strategies for SQL Server- 20mFlying High with Highly Available SQL Server Deployments
20mChallenge to Triumph: Exploring Real-World High Availability in SQL Server Environments