Azure / Azure/Azure-Proactive-Resiliency-Library-v2

❓👂 Question/Feedback - Enable zone redundancy for Azure SQL Database description is incorrect

Open
#688 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
No language data
Stars
105
Forks
125
Avg merge
20m
Merged PRs (30d)
7

Description

## Question/Feedback

The recommendation for [Enable zone redundancy for Azure SQL Database](https://azure.github.io/Azure-Proactive-Resiliency-Library-v2/azure-resources/Sql/servers/#enable-zone-redundancy-for-azure-sql-database-to-achieve-high-availability-and-resiliency) is incorrect. The description is as follows:

"By default, Azure SQL Database premium tier provisions multiple copies within the same region. For geo redundancy, databases can be set as Zone Redundant, distributing copies across Azure Availability Zones to maintain availability during regional outages."

Distributing across zones does not maintain availability during a regional outage.

## Possible Answers/Solutions?

I suggest changing the wording to something like the following:
By default, Azure SQL Database premium tier provisions multiple copies within the same datacenter. For in-region redundancy, databases can be set as Zone Redundant, distributing copies across Azure Availability Zones to maintain availability during datacenter or zone outages.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.