Azure SQL Server DBA

High Availability & Disaster Recovery

Question

Zone redundancy versus cross-region disaster recovery: when does each apply?

Answer

Zone redundancy spreads an Azure SQL Database or elastic pool across availability zones in one region. Cross-region DR maintains recovery capability in another region. Use zone redundancy for zonal failures; use geo-replication or failover groups for regional outages.

This is 4 of 19 free samples for Azure SQL Server DBA.

More Azure SQL Server DBA topic samples