Geek Answers Handbook

Azure SQL Export through https://portal.azure.com Never Terminates

We tried several times to export our sql database, several different copies (regional replication), and we always get a file with zero byte in our memory block. No statuses, error messages.

Any clues?

+5
source share
2 answers

Instead, run the Export Data Layer task from SQL Server Management Studio. This will provide you with detailed export progress.

Step by step instructions:

  • Open SQL Server Management Studio (2016 or higher)
  • Connect to Azure SQL Server
  • Right-click the database you want, select Tasks and Export Data Layer.
  • Follow the wizard
+2
source

get a file with zero byte in our memory block. No statuses, error messages.

This is the expected behavior, this 0-byte file is used to check for permissions for your storage account container. The service will not issue a full BACPAC until the export is complete. it will not save the template data in our repository, and we do not need to pay for the template data. For this reason, you will see that the file size is always 0 bytes. We currently do not have a process panel to show if the export operation has completed on the portal, so please check the resource usage as shown in the following table. if the line returns to normal, check the file again.

enter image description here

-1
source

More articles:


All Articles