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.