ZRS for DTU Basic and Standard Tiers

Njita S 0 Reputation points
2024-01-17T17:48:14.0666667+00:00

Hi Team, I am currently looking at the different DR solutions for Azure SQL databases. I see Zon-redundant backup storage (ZRS) as the High Availability option for Azure SQL databases and from Microsoft documentation (https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#zone-redundant-availability )- this option is only available for General Purpose, Premium, Business Critical & Hyperscale services tiers, and not for Basic & Standard tiers. I went ahead to test this on the portal for BASIC and STANDARD tiers and found that it's possible to configure ZRS for those tiers.
User's image

Can you please explain why the documentation from Microsoft says it's not possible to have ZRS for those services tiers but from the portal it's the opposite? Appreciate your help on this.

Azure SQL Database
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Aleksei Zhukov 0 Reputation points
    2024-01-17T18:15:21.1133333+00:00

    Hi, there is I see a other information in the table "Compare service tiers". Should be fixed by MSFT team https://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-dtu?view=azuresql


  2. Oury Ba-MSFT 20,341 Reputation points Microsoft Employee
    2024-01-17T21:55:05.8533333+00:00

    Hi Njita Silas Halle Welcome to Microsoft Q&A. Thank you for reaching out and for sharing your feedback. In the overview we do document it in a table: High availability - Azure SQL Database | Microsoft Learn User's image

    Also, we will update the following doc (https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla?view=azuresql&tabs=azure-powershell#zone-redundant-availability Regards, Oury

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.