Azure SQL Database export operation stuck at EXPORT DATABASE Cancelling in progress: 50% Some 4-5 Hours already, deleted the storage account it was going to be exported to and server is set to private network access already

Hi there Hugo Souza Almeida Thanks for using QandA platform This maybe due to the deletion of the storage account and the server being set to private network access., check the database's status using the Azure portal make sure it is still functional. If the issue continous i suggest you to, raise a support ticket with Azure Support to forcibly terminate the operation link below https://portal.azure.com/#view/Microsoft_Azure_Support/HelpAndSupportBlade/~/overview If this helps kindly accept the answer thanks much.

Azure SQL Database export operation stuck at cancelling

Accepted answer

Azar 24,600 Reputation points MVP

2024-12-23T19:32:31.69+00:00

Hi there Hugo Souza Almeida

Thanks for using QandA platform

This maybe due to the deletion of the storage account and the server being set to private network access., check the database's status using the Azure portal make sure it is still functional.

If the issue continous i suggest you to, raise a support ticket with Azure Support to forcibly terminate the operation link below

https://portal.azure.com/#view/Microsoft_Azure_Support/HelpAndSupportBlade/~/overview

If this helps kindly accept the answer thanks much.
Please sign in to rate this answer.

1 person found this answer helpful.
Hugo Souza Almeida 20 Reputation points

2024-12-23T19:39:24.77+00:00

Hi azar! I found this link https://learn.microsoft.com/en-us/answers/questions/792465/azure-sql-ongoing-operations-cancel?page=1&orderby=Helpful#answers
It was stuck on 50% before the deletion of the storage account!
Is says one should delete the storage account and change firewall access.
There is a resource lock preventing the private endpoint connection from being deleted, maybe that's it?
I used private link to create it, was stuck at 1% and cancelled it

Azar 24,600 Reputation points MVP

2024-12-23T19:46:18.8666667+00:00

Hi again Hugo Souza Almeida

Tthanks for the info with the resource lock preventing the deletion of the private endpoint connection. the export process depends on consistent access to resources, and removing them mid-operation can cause it to hang possibly. The resource lock on the private endpoint might be blocking the necessary changes, preventing the operation from canceling properly. try removing the resource lock, temporarily adjusting the network settings to allow public access.

If nothing works i suggest you to raise the support req there you will finid help with this the link is above,

Dont forget to accept the answer if it helped, thanks again, merry Christmas.

Hugo Souza Almeida 20 Reputation points

2024-12-23T20:28:38.75+00:00

removed resource lock and deleted connection, can't allow public access over policy, don't have option to support request!
Thank you and merry christmas!

Hugo Souza Almeida 20 Reputation points

2024-12-23T20:51:19.27+00:00

Correction, removing the connection worked! Operation now concluded!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure SQL Database export operation stuck at cancelling

0 additional answers

Your answer