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='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:

https://blog.sqlauthority.com/2018/07/18/sql-server-backup-to-url-script-to-perform-stripped-backup-using-shared-access-signature-sas/

Leave a Reply

Your email address will not be published.