question

juanmaximilianoaguilarabanto-6444 avatar image
0 Votes"
juanmaximilianoaguilarabanto-6444 asked Mike-Ubezzi edited

Sql Azure - backpack 0 megs

Hi

I export a Sql Azure bacpac in a Azure storage, but It always weighs 0 megs.

6891-0000.png



I don't understand, if when I download it in a machine it weight 1.5 megs.

azure-blob-storage
0000.png (6.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

juanmaximilianoaguilarabanto-6444 avatar image
0 Votes"
juanmaximilianoaguilarabanto-6444 answered

Hi
I understand the problem..

This is an expected behavior, this 0 byte file is used to check whether it has permissions to your storage account container. The service will not write out the full BACPAC until the export is complete.

After I wait 10 minutes the sizes of the backup was: 487.29 KiB

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered

You may post this question in a dedicated forum for Azure SQL DB in below. This QnA forum currently doesn't support Azure SQL DB related question.

https://social.msdn.microsoft.com/Forums/en-US/newthread?category=undefined&forum=ssdsgetstarted





If the response helped, do "Mark as answer" or upvote it
- Vaibhav

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Mike-Ubezzi avatar image
0 Votes"
Mike-Ubezzi answered

As stated, can you ask this question in the Azure SQL Database MSDN forum but, I am going to respond to this issue here. This is potentially an Azure Storage issue that is manifesting itself with a .bacpac file. Are you seeing this behavior when you view the .bacpac file in the Azure Portal only? Have you attempted to view this same file in your Azure Storage account with the Azure Storage Explorer desktop client? If not, can you please download/install the client and navigate to the .bacpac file and see if file details are displayed correctly? Please see: Manage Azure Blob Storage resources with Storage Explorer for a full walkthrough of using storage explorer. Like I said, this could be a limitation of viewing the same file through the portal but it would be good to have a screen capture or additional details of this behavior. Thank you!


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.