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='https://mystorageaccount.blob.core.windows.net/b2bb/AdventureWorks-Part1.BAK',
URL='https://mystorageaccount.blob.core.windows.net/b2bb/AdventureWorks-Part2.BAK',
URL='https://mystorageaccount.blob.core.windows.net/b2bb/AdventureWorks-Part3.BAK' WITH FORMAT
in this way your backup is tripped in three files…
use a script like the one there: