Delete a SQL Elastic Pool

Question

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

1. Reopen an old support ticket
2. Somehow create a new support ticket (no idea how I did that)
3. 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

Answer 1

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:

1. Select your Elastic resource.
2. In the Overview section, click on Delete.
3. Confirm that you want to delete the Elastic resource.
4. 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

Answer 2

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>