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"