Hi @TheoEkelmans - you are using the older Backup to URL version that
backs up to page blobs and does not allow more than one backup file. In
recent versions of SQL Server, you should back up to block blobs. See
https://techcommunity.microsoft.com/t5/datacat/sql-server-backup-to-url-a-cheat-sheet/ba...
Hi @Dimitri_Furman 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 TOURL =
'https://ioaaquariussqlbackups01.blob.core.windows.net/sql-backups/SqlManagement_test_part01.bak',URL
=
'https://i...
Hey @Dimitri_Furman , the post starts saying BACKUP URL was added in SQL
2014, but on table, your mention "SQL 2012". Doing some tests, I
confirmed that correct is 2012, as your table shows. I guess that start
of the post was incorrectly typed.
Can we do this on the secondary replica where we are inserting data into
a temporary table as part of a transaction? Our processes takes a lot of
time to dump the data into temporary table as it is selected from
complex joins done on the tables in the AG database on the secondary
replica.
Latest Comments