Properties of SQL Server: <subclient name> (Backup Rules)

Use this dialog box to enable or disable backup rules used to convert backup jobs under special circumstances to prevent failure conditions.

Convert

When selected, switches backup types as indicated under given circumstances.

When cleared:

• All backup jobs for master database will be converted to full backups.
• Backup jobs for msdb and model will run as is.
• For any user defined database, the system will fail the backup jobs that fits these given circumstances.

Log backups

• Convert a log backup to full if a log backup was performed using other software

  Indicates that the next backup should be run as a full backup.

  When a full or differential backup is performed outside of the system, for example, from SQL Enterprise Manager, the next log backups performed using SQL Server iDataAgent are not converted to a full backup. Therefore, it is recommended to run a full backup with the SQL Server iDataAgent. 

• Do not convert log backups to full if log backup was performed using other software

  Indicates that the next backup should be run as a log backup.

  When using this option, make sure to enable the Disable Log Consistency Check in the SQL Settings tab to ensure that the backup job completes successfully. If this option is not selected, the backup job will fail with the error "Backup chain is broken".

When selected the next backup job is switched to a full backup.