Hybrid DR for SQL Server on VMs: distributed AG vs basic AG vs log shipping vs auto-failover group
This sheet compares Distributed availability group, Basic availability group, Log shipping, Auto-failover group.
| Criterion | Distributed availability group | Basic availability group | Log shipping | Auto-failover group |
|---|---|---|---|---|
| What it does | Joins two independent AGs, each with its own WSFC | Single database, single secondary | Ships log backups on a schedule | PaaS cross-region replication and failover |
The verdict, the full comparison, 3 rules and 2 traps are part of DP-300 access. Unlock DP-300.