Migrate to Innovate Summit:
Learn how migrating and modernizing to Azure can boost your business's performance, resilience, and security, enabling you to fully embrace AI.Register now
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Azure SQL Managed Instance provides the ability to cancel some management operations, such as when you deploy a new managed instance or update instance properties.
Overview
All management operations can be categorized as follows:
Instance deployment (new instance creation).
Instance update (changing instance properties, such as vCores or reserved storage).
Go to the Overview pane of your SQL Managed Instance.
Select the Notification box next to the ongoing operation to open the Ongoing Operation page.
Select Cancel the operation at the bottom of the page.
Confirm that you want to cancel the operation.
If the cancel request succeeds, the management operation is canceled and results in a failure. You will get a notification that the cancellation succeeds or fails.
If the cancel request fails or the cancel button is not active, it means that the management operation has entered non-cancelable state and that will finish shortly. The management operation will continue its execution until it is completed.
To cancel a management operation, you need to specify management operation name. Therefore, first use the get command to retrieve the operation list, and then cancel specific the operation.
To cancel the management operation, you need to specify the management operation name. Therefore, first use the get command to retrieve the operation list, and then cancel the specific operation.
Azure CLI
az sql mi op list -g yourResourceGroupName --mi yourInstanceName |
--query"[?state=='InProgress' && isCancellable].{Name: name}"-o tsv |
while read -r operationName; do
az sql mi op cancel -g yourResourceGroupName --mi yourInstanceName -n$operationName
done
For detailed commands explanation, see az sql mi op.
Canceled deployment request
With API version 2020-02-02, as soon as the instance creation request is accepted, the instance starts to exist as a resource, no matter the progress of the deployment process (managed instance status is Provisioning). If you cancel the instance deployment request (new instance creation), the managed instance will go from the Provisioning state to FailedToCreate.
Instances that have failed to create are still present as a resource and:
Are not charged
Do not count towards resource limits (subnet or vCore quota)
Note
To minimize noise in the the list of resources or managed instances, delete instances that have failed to deploy or instances with cancelled deployments.
Next steps
To learn how to create your first managed instance, see Quickstart guide.
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.