SQL Managed Instance and Virtual Cluster Stuck Deleting

Question

I have a sql managed instance and virtual cluster stuck on delete for over 24 hours. I'm not sure the details leading up to this, but the SQL MI was created, but now it shows deleting and is stuck there.

The managed instance is showing it is in deletion phase:

The ongoing operation is the virtual cluster deletion is in progress:

Trying to cancel this operation results in this:

Trying to delete the managed instance via Azure CLI results with ServerNotInSubscription. It seems this deletion process is stuck in limbo. Any suggestion on getting this removed? There are no resource locks. We currently do not have a support plan but hoping the community can provide additional details. I suspect this may be an issue only support can resolve.

Answer 1

Hi @Jeff Brown Tech ,
Locking can sometimes prevent the deletion of a managed instance. I understand you mentioned there are no resource locks, but could you please cross-verify at the resource group level, virtual cluster level, and networking level?

Thank You

Answer 2

Following up on this, the managed instance and virtual cluster remove operations eventually cleaned themselves up and were removed. I did have to remote the vnet, nsg, and route table manually.

Answer 3

@Jeff Brown Tech Thank you for reaching out.

I'm glad that you were able to resolve your issue.

Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer. Accepted answers show up at the top, resulting in improved discoverability for others.

Issue: "I have a sql managed instance and virtual cluster stuck on delete for over 24 hours. I'm not sure the details leading up to this, but the SQL MI was created, but now it shows deleting and is stuck there."

Solution: Customer shared - "The managed instance and virtual cluster removal operations eventually completed and cleaned themselves up".

If your issue remains unresolved or have further questions, please let us know in the comments how we can assist. We are here to help you and strive to make your experience better and greatly value your feedback.

Regards,

Oury