This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Are there any recommendation on backup sql server database to block blob ? Like which blocksize and maxtransfersize is optimal, and also how many backup files can be parallel at each time ?
block blob max size for each sql backup is around 200GB .
Hi @sakuraime ,
Quote from MS document Understanding block blobs, append blobs, and page blobs;
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
thanks . but I am a bit confuse , TSQL backup using BLOCKSIZE is 64KB only
so what's the max blob size of each of the database backup file can be ?
Hi @sakuraime ,
> TSQL backup using BLOCKSIZE is 64KB only
64KB BLOCKSIZE is default for tape device. The device type of Block blobs is URL.
For information about Block blobs, suggest you read the MS document Understanding block blobs, append blobs, and page blobs that I mentioned above.
so what's the block size for backup to URL ?
Hi @sakuraime ,
The default size is 512 for URL, but you do not need to specify this options. This option is unnecessary because BACKUP automatically selects a block size that is appropriate to the device.
512KB block size and how you can get the max size of blob size 190.7 TB ???
Hi @sakuraime ,
I share you the screenshot from MS document due to the sentence that you mentioned in the original post. ‘block blob max size for each sql backup is around 200GB .’