Exporting Azure SQL DB is in progress for a few days!

Today I want to share something about exporting Azure SQL database, it looks simply as it explains here you can go to the database then select Export button on the toolbar then choose the Azure storage account and done! But like other things in technical life, it could be challenging.

I got customer that tried the same things however the process was running for a few days, it showed 1% and nothing change if you have same problem and even, you’re not able to cancel this process in Azure here is the solution.

I found the client tried to export the database and used private link as you can see for now that’s preview but that’s ok, there is no issue with this.
Import Export Private Link is a Service Managed Private Endpoint created by Microsoft and that is exclusively used by the Import-Export, database and Azure Storage services for all communications. The private end point has to be manually approved by user in the Azure portal for both server and storage.

I checked with the client to see if they approve the private endpoint connections, please be aware if you do not approve this that means the process will be waiting for you and they’ll not start!

If you don’t need where and how you need to approve the private endpoint connections go to Private Link Centre then check the pending tab, After the Private End points are approved both in Azure SQL Server and Storage account, Import or Export jobs will be kicked off. Until then, the jobs will be on hold. See the referral link here

So in this case I asked the customer search for “Private Link Center”in Azure Portal, then check is there anything in pending connections if so just approve it, after they approved this the process started, it took 20-30 minutes.