Microsoft
Good article !
But.... 🙂
I'm trying to backup a large database on DB a SQL 2019(CU5) server on an L32s_v2 VM using this command:
BACKUP DATABASE SqlManagement TO
URL = 'https://ioaaquariussqlbackups01.blob.core.windows.net/sql-backups/SqlManagement_test_part01.bak',
URL = 'https://ioaaquariussqlbackups01.blob.core.windows.net/sql-backups/SqlManagement_test_part02.bak',
URL = 'https://ioaaquariussqlbackups01.blob.core.windows.net/sql-backups/SqlManagement_test_part03.bak',
URL = 'https://ioaaquariussqlbackups01.blob.core.windows.net/sql-backups/SqlManagement_test_part04.bak',
URL = 'https://ioaaquariussqlbackups01.blob.core.windows.net/sql-backups/SqlManagement_test_part05.bak',
URL = 'https://ioaaquariussqlbackups01.blob.core.windows.net/sql-backups/SqlManagement_test_part06.bak',
URL = 'https://ioaaquariussqlbackups01.blob.core.windows.net/sql-backups/SqlManagement_test_part07.bak',
URL = 'https://ioaaquariussqlbackups01.blob.core.windows.net/sql-backups/SqlManagement_test_part08.bak'
WITH CREDENTIAL = 'https://ioaaquariussqlbackups01.blob.core.windows.net/sql-backups'
,COMPRESSION
,MAXTRANSFERSIZE = 4194304
,BLOCKSIZE = 65536
,STATS = 5
,NAME = N'SqlManagement-Test Database Backup'
And SQL is not accepting multiple URL's as input as in your example above.
Msg 3294, Level 16, State 1, Line 2
Use of the URL device type is limited to a single device during Backup and Restore operations.
Msg 3013, Level 16, State 1, Line 2
BACKUP DATABASE is terminating abnormally.
Is there some other parameter in SQL 2019 you have to alter before it accepts multiple URL's in the input?
I know we cab achieve awesome speeds from the VM <-> container, because when copying a 1 TB (compressed) backup using AzCopy, it averages at 6 Gbit with peaks reaching 10+Gbit.
And I really do need the parallelism in order to reach my RPO/RTO goals for the VLDB's in Azure.
Theo
