This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 93%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
I've tried to delete the resource group that contains a sql managed instance and failed with lots of different errors. After that, I started by deleting the sql managed instance only. Unfortunately, it remains in "Deleting" state more than a day and I can't delete all the dependent resources as well. Search through google where everyone was saying max 12 hours and etc but it is still in "Deleting" state. I can't even open a support request for this because it is free tier subscription. Any suggestion?
None of the following suggestions work. But at last, took about 6 days to delete the managed instance. What I learned now is that need to manage the cost with the SQL managed instance and the deletion take ?? days to delete.
Hi Mee,
Did you tried removing via the PowerShell force input? - Remove-AzSqlInstance -Name "managedInstance1" -ResourceGroupName "ResourceGroup01" - Force
==
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.
----
Please don't forget to upvote and Accept as answer if the reply is helpful
I got an error with the following:
Remove-AzSqlInstance: Subscription "xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx' does not have the server "managedInstance1"
I tried previously with cli command: az sql mi delete -g mygroup -n myinstance --yes --no-wait
(ServerNotInSubscription) Subscription 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx' does not have the server 'managedInstance1'.
Code: ServerNotInSubscription
Message: Subscription 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx' does not have the server 'managedInstance1'.
when run with az sql mi show -g mygroup -n myinstance or az sql mi op list --managed-instance myinstance -g mygroup
I can see the "state": "Deleting"
Please delete the virtual cluster. Follow the steps provided here. Once you do this the resource group deletion may be able to complete. You can also delete now the VNET.
If after some hours of doing the above, you are unable to see the instance gone, please proceed to create a support ticket to help remove the remnants.
The managed instance is not deleted yet, therefore I can't delete any others. When I do so, I got errors where all the related/dependent resources are still in use. Anyway, the latest documentation stated deleting the virtual cluster manually is not necessary anymore.
Here is the latest statement from the link that you sent to me:
Starting September 1, 2021. all virtual clusters are automatically removed when last instance in the cluster has been deleted. Manual removal of the virtual cluster is not required anymore.
Unfortunately, the managed instance still hanging there with "Deleting" state.
When I tried to create a support ticket related to the issue, it asks me to pay for a monthly support plan fee.
@Mee Lian Lee Just checking back, In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.
Regards
Geetha