SQL Managed Instance and Virtual Cluster Stuck Deleting

Jeff Brown 11 Reputation points
2024-06-12T15:18:12.3833333+00:00

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:

User's image

The ongoing operation is the virtual cluster deletion is in progress:
User's image

Trying to cancel this operation results in this:

User's image

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.

SQL Server on Azure Virtual Machines
Azure SQL Database
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,041 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,739 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. RahulRandive 9,666 Reputation points
    2024-06-12T15:23:50.8733333+00:00

    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

    0 comments
  2. Jeff Brown 11 Reputation points
    2024-06-14T20:00:17.4833333+00:00

    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.

    0 comments
  3. Oury Ba-MSFT 18,941 Reputation points Microsoft Employee
    2024-06-14T22:49:22.5366667+00:00

    @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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.