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
Last activity: Mar 8, 2024, 10:01 AM