Cancel Azure SQL Managed Instance management operations

Applies to: Azure SQL Managed Instance

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 fall into the following categories:

• Instance deployment (new instance creation).
• Instance update (changing instance properties, such as vCores or reserved storage).
• Instance deletion.

You can monitor progress and status of management operations and cancel some of them if necessary.

The following table summarizes management operations, whether you can cancel them, and their typical overall duration:

Category	Operation	Cancelable	Estimated cancel duration
Deployment	Instance creation	Yes	90% of operations finish in 5 minutes.
Update	Instance storage scaling up/down (General Purpose)	No
Update	Instance storage scaling up/down (Business Critical)	Yes	90% of operations finish in 5 minutes.
Update	Instance compute (vCores) scaling up and down (General Purpose)	Yes	90% of operations finish in 5 minutes.
Update	Instance compute (vCores) scaling up and down (Business Critical)	Yes	90% of operations finish in 5 minutes.
Update	Instance service tier change (General Purpose to Business Critical and vice versa)	Yes	90% of operations finish in 5 minutes.
Delete	Instance deletion	No

Cancel management operation

Portal

To cancel management operations by using the Azure portal, follow these steps:

1. Go to the Azure portal.

2. Go to the Overview pane of your SQL Managed Instance.

3. Select the Notification box next to the ongoing operation to open the Ongoing Operation page.

   

4. Select Cancel the operation at the bottom of the page.

   

5. Confirm that you want to cancel the operation.

If the cancel request succeeds, the management operation is canceled and results in a failure. You get a notification that the cancellation succeeds or fails.

If the cancel request fails or the cancel button isn't active, the management operation enters a non-cancelable state and finishes shortly. The management operation continues until it's completed.

PowerShell

If you don't already have Azure PowerShell installed, see Install the Azure PowerShell module.

To cancel a management operation, specify the management operation name. First, use the Get-AzSqlInstanceOperation command to retrieve the operation list, and then cancel the specific operation.

$managedInstance = "<Your-instance-name>"
$resourceGroup = "<Your-resource-group-name>"

$managementOperations = Get-AzSqlInstanceOperation -ManagedInstanceName $managedInstance  -ResourceGroupName $resourceGroup

foreach ($mo in $managementOperations ) {
	if($mo.State -eq "InProgress" -and $mo.IsCancellable){
		$cancelRequest = Stop-AzSqlInstanceOperation -ResourceGroupName $resourceGroup -ManagedInstanceName $managedInstance -Name $mo.Name
		Get-AzSqlInstanceOperation -ManagedInstanceName $managedInstance  -ResourceGroupName $resourceGroup -Name $mo.Name
	}
}

For detailed command explanations, see Get-AzSqlInstanceOperation and Stop-AzSqlInstanceOperation.

Azure CLI

If you don't already have the Azure CLI installed, see Install the Azure CLI.

To cancel a management operation, specify the management operation name. First, use the get command to retrieve the operation list, and then cancel the specific operation.

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 command explanations, see az sql mi op.

Canceled deployment request

By using API version 2020-02-02, as soon as the service accepts the instance creation request, the instance exists as a resource, regardless of the progress of the deployment process (managed instance status is Provisioning). If you cancel the instance deployment request (new instance creation), the managed instance goes from the Provisioning state to FailedToCreate.

Instances that fail to create still exist as a resource and:

• Aren't charged
• Don't count towards resource limits (subnet or vCore quota)

Note

To minimize noise in the list of resources or managed instances, delete instances that fail to deploy or instances with canceled deployments.

Next steps

• To learn how to create your first managed instance, see Quickstart guide.
• For a features and comparison list, see Common SQL features.
• For more information about VNet configuration, see SQL Managed Instance VNet configuration.
• For a quickstart that creates a managed instance and restores a database from a backup file, see Create a managed instance.
• For a tutorial about using Azure Database Migration Service for migration, see SQL Managed Instance migration using Database Migration Service.