SQL Server backup to storage account

sakuraime 2,286 Reputation points

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 .

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,175 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. CathyJi-MSFT 20,801 Reputation points Microsoft Vendor

    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.