How to cancel Azure SQL Database Import or Export operation

[Yochanan_Rachamim]

Purpose: 

This article help you cancel ongoing import or export operation on Azure SQL Database. 

Step by Step guidance: 

1. Open new PowerShell window, you may use cloud shell on Azure portal as well by clicking the cloud shell button at the top right at your portal screen
2. 
3. Copy and paste the following PowerShell code and execute it - it will create a function for the current PowerShell session

4. function Cancel-AzSQLImportExportOperation
   {
       param
       (
           [parameter(Mandatory=$true)][string]$ResourceGroupName
           ,[parameter(Mandatory=$true)][string]$ServerName
           ,[parameter(Mandatory=$true)][string]$DatabaseName
       )
   
       $Operation = Get-AzSqlDatabaseActivity -ResourceGroupName $ResourceGroupName -ServerName $ServerName -DatabaseName $DatabaseName | Where-Object {($_.Operation -like "Export*" -or $_.Operation -like "Import*") -and $_.State -eq "InProgress"}
       
       if(-not [string]::IsNullOrEmpty($Operation))
       {
           do
           {
               Write-Host -ForegroundColor Cyan ("Operation " + $Operation.Operation + " with OperationID: " + $Operation.OperationId + " is now " + $Operation.State)
               $UserInput = Read-Host -Prompt "Should I cancel this operation? (Y/N)"
           } while($UserInput -ne "Y" -and $UserInput -ne "N")
   
           if($UserInput -eq "Y")
           { 
               "Canceling operation"
               Stop-AzSqlDatabaseActivity -ResourceGroupName $ResourceGroupName -ServerName $ServerName -DatabaseName $DatabaseName -OperationId $Operation.OperationId
           }
           else 
           {"Exiting without cenceling the operation"}
           
       }
       else
       {
           "No import or export operation is now running"
       }
   }
   
   Cancel-AzSQLImportExportOperation

5. use the function 

   Cancel-AzSQLImportExportOperation​

   to cancel an Import or Export operation
6. you need to provide the Resource Group name, Server name and Database name where the operation is currently running. 

I hope you find it useful. 

Thank you Roshna Nazir for pointing out this functionality.

if you have any feedback please do not hesitate to provide it in a comment below.

Yochanan.