Azure SQL High Availability and Disaster Recovery

Overview

Explore high availability and disaster recovery options for Azure SQL services in this comprehensive 50-minute video tutorial. Learn about key concepts including RPO and RTO, availability zones, automatic failover groups, and geo-replication. Discover how to implement effective DR failover processes, leverage DNS for seamless transitions, and understand the differences between planned and unplanned failovers. Gain insights into replication technology, listener configurations, and best practices for ensuring business continuity in Azure SQL environments.

Syllabus

- Introduction
- High availability
- HA RPO and RTO and client retry
- Availability Zones
- Server and databases
- Disaster Recovery
- Automatic failover groups
- Geo-replication
- Replication technology
- Forget AUTOMATIC
- DR RPO and RTO
- Performing a failover
- Let DNS do its job
- Planned and unplanned
- How to implement DR failover process
- Listener
- Summary
- Close