Azure SQL backup inconsistent fail


#1

Hi
We are testing your software (SQLBackupAndFTP – trial Professional version) and faced problem.

We use it to backup 30 SQL databases from Azure. From one sql server at night, 1AM as a scheduled job once a day. Full Backups not zipped, not encrypted saved locally on PC that running backup software. Backup options: Backup one DB, send, repeat and Create database snapshot for backup.
We run it already 3 times and some backups failed on first day but was fine on second day and some failed first two days but fine on third and some failed an all 3 days etc. matrix of it below. Error is always same for all of databases – example below.
I picked one of them that failed 3 times (Database5) and created backup job just for this one database with all same settings and backup was successful.
None of the database are over 10GB, Azure SQL server isn’t under any load during backup and none of databases aren’t under read/write or something - we don’t use them at night.

Database 29/10/2019 30/10/2019 31/10/2019
Database1 OK OK Failed
Database2 Failed OK OK
Database3 Failed Failed OK
Database4 OK OK Failed
Database5 Failed Failed Failed
Database6 OK Failed Failed
Database7 OK OK OK
Database8 Failed Failed OK
Database9 Failed Failed OK
Database10 OK Failed Failed
Database11 Failed OK OK
Database12 OK OK Failed
Database13 OK Failed OK
Database14 OK Failed OK
Database15 OK OK Failed
Database16 Failed OK OK
Database17 Failed Failed Failed
Database18 Failed OK OK
Database19 Failed OK Failed
Database20 OK OK Failed
Database21 Failed OK OK
Database22 OK OK OK
Database23 OK OK OK
Database24 Failed OK OK
Database25 OK OK OK
Database26 OK Failed Failed
Database27 OK OK OK
Database28 OK OK OK
Database29 OK OK OK
Database30 OK OK Failed

Error example from log:

29/10/2019 01:36 Creating snapshot of "Database2" database to "Database2_SQLBackupAndFTP_Snapshot"

29/10/2019 01:36 Backing up " Database2_ShelfLife_SQLBackupAndFTP_Snapshot" database to .bacpac file.

29/10/2019 01:38 Drop " Database2_ShelfLife_SQLBackupAndFTP_Snapshot"

29/10/2019 01:38 Failed to backup " Database2_ShelfLife" database with "Full" backup type: One or more unsupported elements were found in the schema used as part of a data package.

Error SQL71501: Error validating element Permission: Permission has an unresolved reference to object .

Error SQL71501: Error validating element Permission: Permission has an unresolved reference to object .

Error SQL71501: Error validating element Permission: Permission has an unresolved reference to object .

Error SQL71501: Error validating element Permission: Permission has an unresolved reference to object .

9/10/2019 01:38 Creating snapshot of "Database9" database to "Database9_SQLBackupAndFTP_Snapshot"


#2

Hi Jacek,

Thank you for the details.

We have checked this issue and can confirm that everything works smoothly on our side. For a backup, we export in a .bacpac file, that operation is always the same.

Could you please check your settings? Sorry, but the issue cannot be resolved from our side.

Sorry for the inconvenience.


#3

@Alexander, what settings should i check?


#4

Hi Jacek_Piszczek,

Please check if you are able to perform a backup via SSMS (SQL Server Management Studio)?