Business Continuity for Hybrid and Cloud Native SQL Server Deployments

on YouTube ↗52m

" summary

Covers concrete designs and gotchas for SQL Server on VMs: always test native backups and plan restores because copying a multi‑terabyte seed can take a week, set realistic RTO/RPOs tied to tested restore times, size VMs for IOPS and network bandwidth, and run cluster validation. Recommends Cloud Witness for hybrid clusters, notes the two replica limit in Standard Edition that forces FCI + AG workarounds, and advises DNS tuning like host record TTL 300s to meet failover windows.

AI-written summary · about

" chapters (5)

1. 0:00Start
2. 1:40Allan's Basic Definitions
3. 4:48Recovery Goals
4. 15:19SQL Server Availability Options
5. 45:29Distributed Network Name

" related talks

• 47mPerfecting business continuity for Azure SQL DBRajesh Setlem · SQLBits 2024
• 47mDisaster Recovery Strategies for SQL ServerAndrew Pruski · SQLBits 2022
• 47mDisaster Recovery Strategies for SQL ServerAndrew Pruski · SQLBits 2024
• 20mFlying High with Highly Available SQL Server DeploymentsAaron West · SQLBits 2024
• 17mMastering the Hybrid Environment: Essential Strategies for DBAsAnat Dror · SQLBits 2024
• 01h 01mAzure SQL Database-Business Continuity During DisasterTaiob Ali · Global Azure Virtual 2021
• 52mMicrosoft SQL Server HA/DR on AWSAsif Mujawar · Conf42 Site Reliability Engineering 2021
• 50mSQL Server to Azure SQL: Performance and AvailabilityBob Ward, Anna Hoffman · SQLBits 2020