Zone Redundency Option not showing on West Europe SQL Elastic pool

Question

Hi,

I have an SQL Elastic Pool in West Europe and another East US and the section where it allows me to enable "Zone Redundancy" isn't showing:

I've successfully enabled it on our UK South Elastic Pool without any issues:

UK South Elastic Pool:

West Europe SQL Elastic pool:

The above print screen is the same for the East US SQL Elastic Pool.

Not sure why because the Microsoft Documentation listed "(Europe) West Europe" and "(North America) East US" as options:

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

I've even tried Azure CLI and I get the below:
After soon searching online I found the answer from Alberto Morillo:

https://learn.microsoft.com/en-us/answers/questions/2103604/unable-to-create-zone-redundant-azure-sql-server-a

Which doesn't help, because:

1. I've been able to do it on a UK South SQL Elastic Pool
2. Our "Subscription" is a normal production, "Pay-as-you-go" Subscription, so our Azure 'Subscription' shouldn't be a problem.

Any ideas would be great.

Answer 1

Hello Callum Woodward,

I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this!

Issue: Customer raised a ticket that Zone Redundancy Option not showing on West Europe SQL Elastic pool.

Error Message: None ("Zone Redundancy" isn't showing, and West Europe SQL Elastic pool is missing).

Solution: Customer was able to get response from Microsoft internal Support: Even though the PowerShell showed EU West and US East were available for Zone Redundancy, Microsoft has confirmed that they aren't available due to high demand.

Email Screeshot: https://learn-attachment.microsoft.com/api/attachments/113de6ad-3c9a-4d9b-8022-003b8f834598?platform=QnA

I hope this is helpful! Do not hesitate to let me know if you have any other questions or clarifications.

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful.

Answer 2

Hi @Callum Woodward

The above issue can cause for few reasons as below:

• Your subscription might have hit its limit for zone-redundant resources. If so, you can request an increase by following the steps in the Azure documentation.
• Some subscriptions also have restrictions on creating zone-redundant resources. Chech if your subscription has any limitation.

If limit is reached for the zone-redundant resources, You can raise support request to increase the quota as below:

• Create a New Support Request with Service and subscription limits (quotas)
• Select Your Quota as Zone Redundant Access (Availability Zones) Select your location and raise the request.

UPDATE:

Sometimes it occurs due to unavailability of Zone redundant databases in particular region due to high demand.

As a workaround you can use another region to create zone redundant database as of now

---

I hope this information helps. Please do let us know if you have any further queries.

Answer 3

Hello Callum Woodward,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

I understand that you are having Zone Redundancy Option not showing on West Europe SQL Elastic pool and ProvisioningDisable error.

Since Zone Redundancy is available in West Europe and East US, but the option is missing, follow these steps for deeper troubleshooting:

STEP 1:

Unlike some features that can be enabled later, Zone Redundancy must be set when the Elastic Pool is initially created. If the UK South Elastic Pool had it enabled at creation, but West Europe and East US did not, this would explain why the option is missing now.

OR Was the Elastic Pool created with Zone Redundancy? If not, you must create a new one with the feature enabled. If the Elastic Pool was created without Zone Redundancy, you will need to create a new Elastic Pool with Zone Redundancy enabled and migrate databases.

STEP 2:

Confirm General Purpose Tier Supports Zone Redundancy in the Specific Azure Region

While the General Purpose tier supports Zone Redundancy, some variations of it might not. Run this Azure CLI command to check the exact capabilities for your region using Azure CLI:

az sql elasticpool listeditions location "West Europe" output table

Then check for zoneRedundant capability in the output.

So, if the output does not list Zone Redundancy, it may not be available in that region for your specific service configuration.

STEP 3:

Since you received a ProvisionDisable error when attempting to enable Zone Redundancy via Azure CLI, this suggests that Azure does not allow enabling this feature post creation.

Try running this command to see the full list of supported parameters in West Europe using Azure CLI: az sql elasticpool show resourcegroup <resourcegroupname> name <elasticpoolname> query "zoneRedundant"

However, if the result is false and you cannot modify it, you will need to create a new Elastic Pool with Zone Redundancy enabled from the beginning.

STEP 4:

Some Azure features roll out regionally in phases. Even though Microsoft’s documentation states that West Europe and East US support Zone Redundancy, this feature might not be fully available to all existing Elastic Pools in those regions. What you need to do is to contact Microsoft support via your Azure Portal by raising a ticket and ask if Zone Redundancy is fully available in West Europe and East US for your subscription.

NOTE:

If none of these steps resolve the issue, the only option is to create a new SQL Elastic Pool with Zone Redundancy enabled and migrate databases accordingly.

I hope this is helpful! Do not hesitate to let me know if you have any other questions or clarifications.

---

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful.