How to cancel Azure SQL Database Import or Export operation

This post has been republished via RSS; it originally appeared at: Azure Database Support Blog articles.

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
  2. Yochanan_MSFT_1-1606432077431.png
  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 -eq "ExportDatabase" -or $_.Operation -eq "ImportDatabase") -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" } }
  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 share it with me at yocr@microsoft.com

 

Yochanan.

 

 

 

REMEMBER: these articles are REPUBLISHED. Your best bet to get a reply is to follow the link at the top of the post to the ORIGINAL post! BUT you're more than welcome to start discussions here:

This site uses Akismet to reduce spam. Learn how your comment data is processed.