2

I have a database backing up into an Azure page blob via URL backups set up from SSMS. I am trying to find out how to split the backup into smaller chunks. I have a 2 TB database that is now backing up in to one large file, I want to separate it into 4 smaller files. Any hints would be helpful.

Environment Summary: Azure VM with SQL 2016 Enterprise Backup Method: URL Backup to Azure Page Blob Security Involved: Key Vault and Credentials Current Status: Backups working Desired Status: Large Backups split into multiple files

I am ok with a powershell example. Thank you

1 Answer 1

0

you should split it into multiple url in this way:

BACKUP DATABASE mydb
TO URL = 'https://mystorage.blob.core.windows.net/mycontainer/mydbBackupSetNumber2_0.bak',
URL = 'https://mystorage.blob.core.windows.net/mycontainer/mydbBackupSetNumber2_1.bak',
URL = 'https://mystorage.blob.core.windows.net/mycontainer/mydbBackupSetNumber2_2.bak'
WITH COMPRESSION, MAXTRANSFERSIZE = 4194304, BLOCKSIZE = 65536;  

ref: https://docs.microsoft.com/en-us/archive/blogs/sqlcat/backing-up-a-vldb-to-azure-blob-storage

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.