Delete a subnet after deleting a managed instance of SQL Managed Instance

APPLIES TO: Azure SQL Managed Instance

This article provides guidelines on how to manually delete a subnet after deleting the last managed instance of Azure SQL Managed Instance residing in it.

Managed instances are deployed into virtual clusters. Each virtual cluster is associated with a subnet. The virtual cluster persists by design for 12 hours after the last instance deletion to enable you to more quickly create managed instances in the same subnet. There's no charge for keeping an empty virtual cluster. During this period, the subnet associated with the virtual cluster can't be deleted.

If you don't want to wait 12 hours and prefer to delete the virtual cluster and its subnet sooner, you can do so manually. Delete the virtual cluster manually by using the Azure portal or the Virtual Clusters API.

Important

  • The virtual cluster should contain no managed instances for the deletion to be successful.
  • Deletion of a virtual cluster is a long-running operation lasting for about 1.5 hours (see Managed instance management operations for up-to-date virtual cluster delete time). The virtual cluster will still be visible in the portal until this process is completed.

Delete a virtual cluster from the Azure portal

To delete a virtual cluster by using the Azure portal, search for the virtual cluster resources.

Screenshot of the Azure portal, with search box highlighted

After you locate the virtual cluster you want to delete, select this resource, and select Delete. You're prompted to confirm the virtual cluster deletion.

Screenshot of the Azure portal Virtual clusters dashboard, with the Delete option highlighted

Azure portal notifications will show you a confirmation that the request to delete the virtual cluster has been successfully submitted. The deletion operation itself will last for about 1.5 hours, during which the virtual cluster will still be visible in portal. Once the process is completed, the virtual cluster will no longer be visible and the subnet associated with it will be released for reuse.

Tip

If there are no managed instances shown in the virtual cluster, and you are unable to delete the virtual cluster, ensure that you do not have an ongoing instance deployment in progress. This includes started and canceled deployments that are still in progress. This is because these operations will still use the virtual cluster, locking it from deletion. Reviewing the Deployments tab of the resource group the instance was deployed to will indicate any deployments in progress. In this case, wait for the deployment to complete, delete the managed instance, and then delete the virtual cluster.

Delete a virtual cluster by using the API

To delete a virtual cluster through the API, use the URI parameters specified in the virtual clusters delete method.

Next steps