Azure SQL Managed Backup

Posted on

Question :

I have a SQL 2017 on-prem database server that the client wants to back up to Azure storage directly; instead of using local storage. The largest database backup is 4-5TB. I read the MS documentation and it states this ‘SQL Server Managed Backup to Microsoft Azure uses the Backup to Block Blob feature. The maximum size of a block blob is 200 GB. But by utilizing striping, the maximum size of an individual backup can be up to 12 TB. ‘
What does it mean by striping?? Do I need to get Premium storage for striping??
Thanks a bunch.

Answer :

striping means to use multiple to urls in this way:

BACKUP DATABASE AdventureWorks2016

TO URL='',



in this way your backup is tripped in three files…

use a script like the one there:

Leave a Reply

Your email address will not be published. Required fields are marked *