Azure SQL Ongoing operations cancel

ronis 26 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
{count} votes

1 answer

Sort by: Most helpful
  1. Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
    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.


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.