Delete a SQL Elastic Pool

Rob Marsh 0

F&*k me, this support process is diabolical! I have managed to:

Reopen an old support ticket
Somehow create a new support ticket (no idea how I did that)
Finally found a post mentioning that MS have removed Email/Phone support from Developer tier, so thought I would try here too!

I have created an Elastic Pool in Azure, but I have assigned no databases to it. I created it because it wouldn't give me options to pause the serverless VCore pool like it does when you create a serverless VCore database. I wanted to see if it gave me the option to configure pause settings once it was created (it didn't by the way).

Anyway, now I have created an expensive elastic pool that is providing zero benefit, so I need to delete it. I get an error message preventing the delete because of a lock that is on the SQL Server. I don't want to risk deleting the server by removing that lock. I don't want to delete the server or any of the databases on that server, just the redundant elastic pool that was created with zero assigned databases.

Thanks

Mallaiah Sangi 90 Reputation points Microsoft External Staff

2025-03-03T08:49:11.1466667+00:00
Hi @Rob Marsh

Please see the below link which may helpful for resolving the issue.

https://learn.microsoft.com/en-us/rest/api/sql/elastic-pools/delete?view=rest-sql-2021-11-01&tabs=HTTP.

To delete an Elastic Pool in Azure Portal, you can follow these steps

Sign in to the Azure Portal:

Select your Elastic resource.

In the Overview section, click on Delete.

Confirm that you want to delete the Elastic resource.

Once deleted, logs will no longer be sent to Elastic and billing stops. Alternatively, you can use the Remove-AzSqlElasticPool cmdlet to delete an Azure SQL Database elastic pool. I hope, This response will address your query and helped you to overcome on your challenges

1 answer

Alberto Morillo 34,546 Reputation points MVP

2025-02-26T15:18:43.2133333+00:00
Try removing it using Azure CLI:

az sql elastic-pool delete --name <elastic-pool-name> --resource-group <resource-group-name> --server <logical-server-name>

If you are still not allowed, you can disable the lock temporarily.

az lock delete --name <lock-name> --resource-group <resource-group-name>

And reapply it after removing the elastic pool.

az lock create --name <lock-name> --resource-group <resource-group-name> --lock-type Delete --resource <resource-id>
Please sign in to rate this answer.
Rob Marsh 0 Reputation points

2025-03-01T12:51:40.9+00:00

Thanks Alberto. I don't have much experience of using Azure CLI, and will definitely look into it some more, but for now I am looking at ways to do this through the Azure Portal.

More than that, my main concern is that I do not want to delete the SQL Server instance by removing the lock and then deleting the elastic pool. I am looking for confirmation from a Microsoft support engineer that this will not happen. Apparently, with Developer level support, responses from Microsoft Support Engineers are now prioritised on this Q&A, but seeing as this was posted 5 days ago and nobody has responded, it's not a great advert for the paid support!

Alberto, apologies if you are a Microsoft Support Engineer, but looking at your profile, I don't think you are. Happy to be corrected though ;)

Alberto Morillo 34,546 Reputation points MVP

2025-03-02T21:26:58.9+00:00

Agree with you. I am just a volunteer. Please wait for Microsoft Support Engineer.

Balmukund 81 Reputation points Microsoft Employee

2025-03-03T16:11:43.3066667+00:00

@Rob Marsh

I am also not a support engineer but am part of Azure SQL product group. :)

If you can share your support ticket number here or send me privately, I can look into it.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Delete a SQL Elastic Pool

1 answer

Your answer