Azure-docs: auto-failover groups versus active geo-replication in first table

[flotsam7jetsam]

Looks like auto-failover groups in the first table for business continuity should really be active geo-replication--at least compared to all the other azure documentation I've read. Thanks for the table; that's why I'm reading this document.

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 18c9d161-a06b-6b68-8f54-c22fcc7088da
• Version Independent ID: b215e7fa-dc6a-48ee-418b-93709813566e
• Content: Cloud business continuity - database recovery - SQL Database
• Content Source: articles/sql-database/sql-database-business-continuity.md
• Service: sql-database
• GitHub Login: @anosov1960
• Microsoft Alias: sashan

[Mike-Ubezzi-MSFT]

@MarkWSolomon Thank you for the detailed feedback. Auto Failover Groups applies to multiple databases where Active Geo-Replication apples to an individual database. Auto Failover Groups uses the same underlying technology as Active Geo-Replication. This technology applies to disaster recovery use cases.

Use auto-failover groups to enable transparent and coordinated failover of multiple databases

Auto-failover groups is a SQL Database feature that allows you to manage replication and failover of a group of databases on a SQL Database server or all databases in a Managed Instance to another region (currently in public preview for Managed Instance). It uses the same underlying technology as active geo-replication.

Create readable secondary databases using active geo-replication

Active geo-replication is Azure SQL Database feature that allows you to create readable secondary databases of individual databases on a SQL Database server in the same or different data center (region).
Active geo-replication is designed as a business continuity solution that allows the application to perform quick disaster recovery of individual databases in case of a regional disaster or large scale outage. If geo-replication is enabled, the application can initiate failover to a secondary database in a different Azure region. Up to four secondaries are supported in the same or different regions, and the secondaries can also be used for read-only access queries.

[Mike-Ubezzi-MSFT]

@MarkWSolomon We will now proceed to close this thread. If there are further questions regarding this matter, please comment and we will gladly continue the discussion.

[MNF]

@Mike-Ubezzi-MSFT

Auto Failover Groups applies to multiple databases where Active Geo-Replication applies to an individual database.

Is it included in the documentation? I’ve read a few articles about Geo-Replication/Auto Failover Groups, but haven’t seen it. It will be useful to clarify differences between these terms.

[Mike-Ubezzi-MSFT]

@MNF I have submitted a PR to add a NOTE to the linked doc. It will appear in the following section.

[Mike-Ubezzi-MSFT]

@anosov1960 I have submitted a PR for your review/edit/approval. @CarlRabeler for awareness.

[CarlRabeler]

@MashaMSFT for awareness

[stevestein]

Info was added to the article and will appear live sometime today.
We will now proceed to close this thread. If there are further questions regarding this matter, please comment and we will gladly continue the discussion.

[stevestein]

please-close