SQL Backup file size to Azure Blob bigger

Question

SQL Backup file size to Azure Blob bigger

Prakash Rameshchandra Nandwana 6

I have a SQL Server running on Azure VM whose backup size to Blob storage account is 10 times bigger than on local disk on that server.
The SQL Server database backup to disk on the same VM is 400MB, but same database when backup from SQL Server to URL Blob storage is about 4.2GB.
Any help will be much appreciated.

Ravi Kanth Koppala 3,396 Reputation points Microsoft Employee Moderator

2022-03-04T00:19:47.047+00:00
@Prakash Rameshchandra Nandwana ,
Thank you for reaching out to the Microsoft Q&A platform. Happy to answer your question.

There might be many reasons why the file size is bigger in Azure

Did you take any file snapshots?

Did you have file versions?

The file might have used space that fills the table. The quick fix was to add clustered index and a clean index. For more details refer to https://social.msdn.microsoft.com/Forums/en-US/065242f4-b1bc-46f7-b7e6-5b28a0e22622/why-database-size-is-1000-times-bigger-in-azure-than-onpremise?forum=ssdsgetstarted

Can you please validate these items, and confirm if you can identify the root cause?
Leslie Teoh 0 Reputation points

2024-05-30T03:35:21.4633333+00:00
Hi,

I have the same question,

no snapshot taken

SQL version 12

this link does not seem to be working
Sumarigo-MSFT 47,511 Reputation points Microsoft Employee Moderator

2024-05-30T05:19:33.3433333+00:00

@Leslie Teoh I would recommend to please create a New thread with complete details of your issue.
https://learn.microsoft.com/en-us/answers/questions/ask/