Azure SQL Managed Instance stuck in Provisioning state - 10 hours

Chris Peacock 6 Reputation points
2022-11-02T09:01:15.197+00:00

We deployed a SQL Managed Instance. 10 hours later it's still provisioning. It usually takes 3-4 hours.

How can we force delete?

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. ShaktiSingh-MSFT 14,186 Reputation points Microsoft Employee
    2022-11-02T11:07:43.107+00:00

    Hi @Chris Peacock ,

    Welcome to Microsoft Q&A platform and thanks for using Azure Services.

    As I understand from the question, the Azure SQL Managed Instance is stuck in Provisioning State from over 10 hours, and you want to force delete it.

    This might be caused if the managed instance is created shortly after deleting a managed instance by the same name. Delete operation interferes with the create operation.
    This could be avoided by choosing an instance name that was different form the one deleted.

    There could be some other internal reasons too which could cause this stuck state of the MI.

    Regarding delete, could you please try below Azure CLI command:

    256337-image.png

    Reference link: az-sql-mi-delete

    Please let us know if this helps. If any further queries, do reply.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you.
      Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification