Azure SQL Database - No zone redundant option

Question

After converting an Azure SQL Database to a Serverless vCore purchase option, there seems to be no option to enable zone redundancy. This issue also occurs with Elastic Pools using the vCore purchase model.

Based on the following article, the General Purpose Serverless tier offer a zone redundant, our region (SouthEast Asia) also supported this zone redundant feature.

https://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla-local-zone-redundancy?view=azuresql&tabs=azure-powershell#general-purpose-service-tier

https://learn.microsoft.com/en-us/azure/reliability/regions-list

An attempt to update via Azure CLI resulted in an error. Please see the screenshot below for reference:

What steps can be taken to enable zone redundancy for this database and elastic pool in our subscription ?

We also manage a different Azure subscription with the region of Southeast Asia, and there is zone redundant option

Is there any setting that we need to enable within the Subscription ?

Answer 1

Hi Ricky,

Please carefully follow my instructions below to create a new Service and subscription limits (quotas) request to allow access to SQL Zone redundancy for the subscription/region you need.

1. Navigate to this link to start the process:

https://portal.azure.com/#view/Microsoft_Azure_Support/HelpAndSupportBlade/~/overview

2. Click Create a support request button at top

3. If you see Support AI Assistant as shown below, click Switch to old experience button on right. If not, proceed to step #4

4. Enter subscription limit in the box and click Go

5. Click Create a support request button, as shown

6. Select Issue type: Service and subscription limits (quotas), Subscription: <subscription where you need SQL zone redundancy, Quota type: SQL database, click Next

7. Now you should be on Additional details tab. Click Enter details

8. Select Zone Redundant Access (Availability Zones), select Location you need, enter number of cores, enter additional details in description box, click Save and continue

9. Finish filling out Additional details tab, click Next, review and click Create. You should receive an automated email within a few minutes.

Please click Accept Answer and upvote if the above was helpful.

Thanks.

-TP