Stop / Cancel ongoing Azure SQL DB scale operation
Published Mar 13 2019 06:57 PM 6,586 Views

First published on MSDN on Mar 21, 2018
Scenario:

if you want to cancel updating database pricing tier. this can be due to mistake, or long running scale operation.

Resolution:



    1. open Azure cloud shell or use your local Azure CLI installation.

 

    1. edit the following command with your database details and execute the script

 

$ResourceGroupName = ""
$ServerName = ""
$DatabaseName = ""
#----------------------------------------
$OperationName = (az sql db op list --resource-group $ResourceGroupName --server $ServerName --database $DatabaseName --query "[?state=='InProgress'].name" --out tsv)
if(-not [string]::IsNullOrEmpty($OperationName))
{
(az sql db op cancel --resource-group $ResourceGroupName --server $ServerName --database $DatabaseName --name $OperationName)
"Operation " + $OperationName + " has been canceled"
}
else
{
"No in progress operation found"
}

 



    1. review the output to confirm operation has been canceled.

 

2 Comments
Version history
Last update:
‎Nov 26 2020 01:56 AM
Updated by: