Zone Redundency Option not showing on West Europe SQL Elastic pool

Callum Woodward 1 Reputation point
2025-02-18T11:44:41.7033333+00:00

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:User's image

West Europe SQL Elastic pool:
User's image

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:
User's imageUser's image 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.

Azure SQL Database
{count} votes

2 answers

Sort by: Most helpful
  1. Sina Salam 18,126 Reputation points
    2025-02-19T14:37:35.5533333+00:00

    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.


  2. PratikLad 80 Reputation points Microsoft Vendor
    2025-02-20T12:02:48.2633333+00:00

    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.

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


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.