I am attempting to backup a database to my Azure Blob storage. The databases are relatively large... between 1 and 30 Gig.
I have successfully backed up the first day, but on subsequent days, I get an error stating that the file already exists and that I need to use the WITH FORMAT.
But I need to do a differential backup, as the load of data on a full backup would be very slow and pricey.
I get the error "MyBackup.bak exists on the remote endpoint, and WITH FORMAT was not specified.".
What I am trying to do is:
BACKUP DATABASE [MyDatabase]' TO URL = 'https://myaccount.blob.core.windows.net/dbbackups/Container/', MyDatabase.bak', WITH CREDENTIAL = 'AzureDBBackupsContainer' , DIFFERENTIAL , COMPRESSION;
I have seen that a differential backup is supported when using URL backups.
Is this actually not possible, or am I doing something wrong? Do I need to somehow change the file name each day?