Got some issues with a stuck azure sql bacpac import preventing me from importing the bacpac again to the database with the same name.
The file is being pulled in from an Azure storage account. I was importing a bacpac file (575mb) of a database that's 16gb. I thought the database import had stalled and deleted the database that was created as part of the import. Since discovered that the import was still in flight.
Now when i try and create another import of the database with the same name.
I've tried running az sql db op list to list the job but as the database no longer exists it errors (i deleted it thinking it had failed but the jobs still there in the background).
Also tried the same via the Microsoft API - https://docs.microsoft.com/en-us/rest/api/sql/databaseoperations/cancel but that gives a 404 as the database isn't there.
Anyone any idea on how I can cancel the stuck job?
No support on the account at the moment so my idea of contacting MS has gone. Is there a timeout on the job?
0 Answers