取消 Azure SQL 托管实例管理操作Canceling Azure SQL Managed Instance management operations

若要使用 Azure 门户取消管理操作，请执行以下步骤：To cancel management operations using the Azure portal, follow these steps:

1. 转到 Azure 门户Go to the Azure portal

2. 转到 SQL 托管实例的“概述”边栏选项卡。Go to the Overview blade 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.

如果尚未安装 Azure PowerShell，请参阅安装 Azure PowerShell 模块。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. 因此，首先使用 get 命令以检索操作列表，然后取消特定操作。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
    }
}

有关详细的命令说明，请参阅 Get-AzSqlInstanceOperation 和 Stop-AzSqlInstanceOperation。For detailed commands explanation, see Get-AzSqlInstanceOperation and Stop-AzSqlInstanceOperation.

如果尚未安装 Azure CLI，请参阅安装 Azure CLI。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. 因此，首先使用 get 命令以检索操作列表，然后取消特定操作。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

有关详细的命令说明，请参阅 az sql mi op。For detailed commands explanation, see az sql mi op.