你当前正在访问 Microsoft Azure Global Edition 技术文档网站。 如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。
Stop-AzSqlInstanceOperation
Stops a SQL managed instance's operations.
Syntax
Stop-AzSqlInstanceOperation
[-Name] <String>
[-ManagedInstanceName] <String>
[-ResourceGroupName] <String>
[-Force]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Stop-AzSqlInstanceOperation
[-ResourceId] <String>
[-Force]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Stop-AzSqlInstanceOperation
[-InputObject] <AzureSqlManagedInstanceOperationModel>
[-Force]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Description
The Stop-AzSqlInstanceOperation cmdlet stops operation with provided operation name on a SQL managed instance.
Examples
Example 1: Get a specific operation
Stop-AzSqlInstanceOperation -ResourceGroupName ps3753 -ManagedInstanceName ps3698 -Name d0f5bef5-e2b1-4ef8-bb42-2e54073874f9
Id : /subscriptions/a8c9a924-06c0-4bde-9788-e7b1370969e1/resourceGroups/ps3753/providers/Microsoft.Sql/managedInstances/ps3698/operations/d0f5bef5-e2b1-4ef8-bb42-2e54073874f9
ResourceGroupName : ps3753
ManagedInstanceName : ps3698
Name : d0f5bef5-e2b1-4ef8-bb42-2e54073874f9
Operation : UpsertManagedServer
OperationFriendlyName : UPDATE MANAGED SERVER
PercentComplete : 0
StartTime : 3/16/2020 12:49:53 PM
State : InProgress
ErrorCode :
ErrorDescription :
ErrorSeverity :
IsUserError :
EstimatedCompletionTime :
Description :
IsCancellable : TrueThis command stops operation with name 'd0f5bef5-e2b1-4ef8-bb42-2e54073874f9' on a SQL managed instance.
Example 2: Using operation resource id
$managedInstanceOperation = Get-AzSqlInstanceOperation -ResourceGroupName ps3753 -ManagedInstanceName ps3698 -Name 4253bf58-34f1-4499-80c6-198d94c659f7
Get-AzSqlInstanceOperation -ResourceId $managedInstanceOperation.Id
Id : /subscriptions/a8c9a924-06c0-4bde-9788-e7b1370969e1/resourceGroups/ps3753/providers/Microsoft.Sql/managedInstances/ps3698/operations/4253bf58-34f1-4499-80c6-198d94c659f7
ResourceGroupName : ps3753
ManagedInstanceName : ps3698
Name : 4253bf58-34f1-4499-80c6-198d94c659f7
Operation : UpsertManagedServer
OperationFriendlyName : UPDATE MANAGED SERVER
PercentComplete : 0
StartTime : 3/16/2020 12:47:32 PM
State : InProgress
ErrorCode :
ErrorDescription :
ErrorSeverity :
IsUserError :
EstimatedCompletionTime :
Description :
IsCancellable : TrueThis command stops operation with resource id $managedInstanceOperation.Id.
Example 3: Using operation object
$managedInstanceOperation = Get-AzSqlInstanceOperation -ResourceGroupName ps3753 -ManagedInstanceName ps3698 -Name b15a2b78-c42c-4e00-bf87-7ef4737552dc
Stop-AzSqlInstanceOperation -InputObject $managedInstanceOperation
Id : /subscriptions/a8c9a924-06c0-4bde-9788-e7b1370969e1/resourceGroups/ps3753/providers/Microsoft.Sql/managedInstances/ps3698/operations/b15a2b78-c42c-4e00-bf87-7ef4737552dc
ResourceGroupName : ps3753
ManagedInstanceName : ps3698
Name : b15a2b78-c42c-4e00-bf87-7ef4737552dc
Operation : UpsertManagedServer
OperationFriendlyName : UPDATE MANAGED SERVER
PercentComplete : 0
StartTime : 3/16/2020 12:44:57 PM
State : InProgress
ErrorCode :
ErrorDescription :
ErrorSeverity :
IsUserError :
EstimatedCompletionTime :
Description :
IsCancellable : TrueThis command stops operation with object $managedInstanceOperation.
Parameters
-Confirm
Prompts you for confirmation before running the cmdlet.
| Type: | SwitchParameter |
| Aliases: | cf |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DefaultProfile
The credentials, account, tenant, and subscription used for communication with Azure.
| Type: | IAzureContextContainer |
| Aliases: | AzContext, AzureRmContext, AzureCredential |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Force
Skip confirmation message for performing the action
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-InputObject
The operation to cancel
| Type: | AzureSqlManagedInstanceOperationModel |
| Aliases: | SqlInstanceOperation |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-ManagedInstanceName
The name of the instance.
| Type: | String |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Name
The name of the operation.
| Type: | String |
| Aliases: | OperationName |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ResourceGroupName
The name of the resource group.
| Type: | String |
| Position: | 1 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ResourceId
The resource id of operation object to stop
| Type: | String |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-WhatIf
Shows what would happen if the cmdlet runs. The cmdlet is not run.
| Type: | SwitchParameter |
| Aliases: | wi |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Inputs
AzureSqlManagedInstanceOperationModel
