Question/Feedback
The recommendation for Enable zone redundancy for Azure SQL Database 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.
Question/Feedback
The recommendation for Enable zone redundancy for Azure SQL Database 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.