Canceling Azure SQL Managed Instance management operations

To cancel management operations 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 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.

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

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.

$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 commands explanation, see Get-AzSqlInstanceOperation and Stop-AzSqlInstanceOperation.

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

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.

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.