Sample Header Ad - 728x90

What are recommended values for block size, buffercount and maxtransfer size for Ola backups to Azure?

0 votes
1 answer
880 views
I have SQL servers running on onprem and Azure VM hardware. The backups write to a file share located on a network VM. I am wanting to change the backup destination to Azure blob storage. For this I have created an Azure storage account and tested the Ola backup script with credentials (account key/identity and also with shared access signature). Is want some guidance on what is recommended values to use for the following: 1. Block size 2. Buffer count 3. Max transfer size I understand that the block blob has a 200GB file limit and this is OK for me as my compressed backups come to under 110GB. I understand that Azure blob has a limitation of 50000 blocks * 4MB maxtransfersize. What is the idea values to use so that I don't hit the above limit.
Asked by variable (3590 rep)
Mar 8, 2024, 09:24 AM
Last activity: Mar 8, 2024, 10:01 AM