Azure SQL DB Export operations running for long time and timed out

Question

We are experiencing an issue with an export operation getting stuck at 47% for 2 days, and the operation timed out after 48 hours

PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community.

Answer 1

Greetings!

Welcome to Microsoft Q&A forum.

What causes delays in the process?

The Azure SQL Database Import/Export service provides a limited number of compute virtual machines (VMs) per region to process import and export operations. The compute VMs are hosted per region to make sure that the import or export avoids cross-region bandwidth delays and charges. If too many requests are made at the same time in the same region, significant delays can occur in processing the operations. The time that's required to complete requests can vary from a few seconds to many hours.

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

Please note- After resources are assigned and a request starts to process, the service automatically cancels the request after two days.

To resolve such issue, please reinitiate the export operation with more vcores and increase the storage size and once the export operation completed, you can downscale the pricing tier.

Thank You!