Unable To Export Azure SQL Database

Question

For some reason I am unable to export one of my databases to a BAC file. I clicked the export button, added the correct credentials as normal, and I got the message saying it was accepted. Usually takes around 5 minutes to create the BAC file in my blob storage. However, as you can see from below, over 40 minutes ago and it still says accepted (This is a very small database - 230mb). I have done another DB just before this one and that succeeded fine (As you can see). I have tried again to export the DB that was accepted but never completed, but now I get an undefined error now (See below)

Answer 1

Hi Lee,

Thanks for reaching out to Microsoft Q&A.

have you gone through this already? tried the fix and getting the same error?

https://learn.microsoft.com/en-us/azure/azure-sql/database/database-import-export-hang?view=azuresql

Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.

Answer 2

Hi @Lee
Which region is your database hosted and do you have operation id for failed export operation? (You can get from SQL Server—Import/Export History) As alternative you can also try using SQL Server Management studio or SQL Package/CLI Command Here is a blog for reference. Thank you!