Azure SQL Ongoing operations cancel

ronis 16 Reputation points
2022-03-29T18:35:42.133+00:00

I tried to export Azure SQL database and that got stuck for several hours in 1%. After that I cancelled export process with Powershell and now it's stuck for cancel in progress...

I have tried to scale database but that didn’t do anything.

What else can I do?

187929-screenshot-2022-03-29-at-213432.png

188035-screenshot-2022-03-29-at-212302.png

Azure SQL Database
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 33,861 Reputation points MVP
    2022-03-29T19:54:29.187+00:00

    The cancelllation will probably finish on 3-4 hours, but you can also try the following if those hours turn into a lot more than that.

    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.

  2. ronis 16 Reputation points
    2022-04-22T07:46:24.05+00:00

    The operation is still running. I think I have to open ticket for Azure support...

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.