Handling SQL databases during incremental backups
Actually users have to create two job-policies per SQL installation. One for databases in "simple" mode (only full backups) and one for "full" mode databases (full and incremental backups).
If you choose to backup all databases with only full backups, BE warns you to run incremental backups to truncate the log files, if you try to backup all databases with full/incremental policies, you get the error messages, that the "simple" databases do not support log file backups.
Therefore my question:
Why not ask the admin, how to handle "simple" mode databases during incremental backups. You could give the two options:
- Skip simple mode databses
- Failover to full backup when detecting a simple mode database during an incremental backup
This would make things much easier, especially because many admins have only few or even no know-how regarding SQL.
All the best from Germany,