Stop / Cancel ongoing Azure SQL DB scale operation

[Yochanan_Rachamim]

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.