Azure SQL Database export stuck in CancelInProgress status

Question

Azure SQL Database export stuck in CancelInProgress status

Tom 276

I initiated a Azure SQL database export that needed to be cancelled. I used the Stop-AzSqlDatabaseActivity cmdlet and the operation status changed to CancelInProgress. It has been stuck in that status for over 24 hours. How long should it take to complete the cancellation? Does it need to be cancelled another way?

Alberto Morillo 35,506 Reputation points MVP Volunteer Moderator

2025-11-02T21:25:50.8266667+00:00
The cancellation operation usually takes 3-4 hours, but you can also try the following if those hours turn into a lot more than that as in your scenario:

Can you delete the storage account you were using to export? If you don't have other files there.

Try setting the firewall with the option "Allow Azure services and resources to access this server" to No.
Anonymous

2025-11-03T02:01:24.44+00:00

Hi Tom,

Thank you for reaching out to Microsoft Q&A. To proceed with further investigation, we’ll need some additional details. Please share the requested information in the Private Message section.
Anonymous

2025-11-03T08:47:38.4433333+00:00
Hi Tom,

Here are the detailed steps to mitigate your reported issue.

Rest API - Documentation: Cancel Database Operation REST API

Powershell - Documentation: Stop-AzSqlDatabaseActivity
Anonymous

2025-11-04T09:25:55.7466667+00:00
Hi Tom,

Can you please verify the logs and give the exact error or screenshot.

Check Activity Logs: Navigate to the Azure portal and check the activity logs for any additional errors or issues that might explain the prolonged cancellation process. This might give insights into whether the cancellation is encountering any conflicts or resource limitations.

To move further we need your subscription and server details can you please provide these details over Private messaging

And also, as suggested by Alberto did you get a chance to check the firewall setting. Please do let us know if it still stuck in cancelation. we will try to guide you in right way.

Thanks!

1 answer

Your answer

Alberto Morillo 35,506 Reputation points MVP Volunteer Moderator

2025-11-02T21:25:50.8266667+00:00

The cancellation operation usually takes 3-4 hours, but you can also try the following if those hours turn into a lot more than that as in your scenario:

Can you delete the storage account you were using to export? If you don't have other files there.

Try setting the firewall with the option "Allow Azure services and resources to access this server" to No.
Anonymous

2025-11-03T02:01:24.44+00:00

Hi Tom,

Thank you for reaching out to Microsoft Q&A. To proceed with further investigation, we’ll need some additional details. Please share the requested information in the Private Message section.
Anonymous

2025-11-03T08:47:38.4433333+00:00

Hi Tom,

Here are the detailed steps to mitigate your reported issue.

Rest API - Documentation: Cancel Database Operation REST API

Powershell - Documentation: Stop-AzSqlDatabaseActivity
Anonymous

2025-11-04T09:25:55.7466667+00:00

Hi Tom,

Can you please verify the logs and give the exact error or screenshot.

Check Activity Logs: Navigate to the Azure portal and check the activity logs for any additional errors or issues that might explain the prolonged cancellation process. This might give insights into whether the cancellation is encountering any conflicts or resource limitations.

To move further we need your subscription and server details can you please provide these details over Private messaging

And also, as suggested by Alberto did you get a chance to check the firewall setting. Please do let us know if it still stuck in cancelation. we will try to guide you in right way.

Thanks!

Answer 1

Tom 276

The issue has been resolved. The problem was that I had rejected a private link connection but I needed to delete the rejected private endpoints from the storage account and the SQL server before the operation could be cancelled.

Anonymous

2025-11-04T16:45:00.2+00:00

Hi Tom,

Glad to know that your issue is resolved, If you have any further queries, please feel free to post your queries on Microsoft Q&A in future.

Thanks!

Share via

Azure SQL Database export stuck in CancelInProgress status

1 answer

Your answer