Azure SQL business continuity: zone redundancy vs failover groups vs geo-replication vs geo-restore
This sheet compares Zone redundancy, Active geo-replication, Auto-failover groups, Geo-restore.
| Criterion | Zone redundancy | Active geo-replication | Auto-failover groups | Geo-restore |
|---|---|---|---|---|
| Scope | Availability zones within one region | Readable secondary in another region | Cross-region group behind a single listener | Rebuild from geo-redundant backups in any region |
The verdict, the full comparison, 5 rules and 2 traps are part of DP-300 access. Unlock DP-300.