Backup Conversion Settings for the SQL Server Agent
Backup conversion settings provide a mechanism for converting one backup type to another backup type if certain conditions are satisfied. If the condition is met, the action or conversion is performed. You can use the backup conversion settings to convert backup type either for default and database subclients or for file and filegroup subclients.
The conversion settings ensure that SQL data is backed up regardless of the circumstances that may cause a backup failure.
|Subclient Type||Conversion Type||Conditions for Conversion||Benefits of Conversion|
|Default and database subclients||Log backup to differential backup||Database recovery model is set to simple.||Simple recovery model does not support log backups. Converting log backup to differential backup ensures that both logs and data are backed up. The backed up data is later used to restore logs and data.|
|Default and database subclients||Differential backup to full backup||Previous full backup was performed using software other than Commvault.||For the first time users of Commvault, starting with a full backup operation ensures complete data protection. Full backup of data also acts as a baseline for future backups and restores.|
|All backups to full backup||
||Converting to full backups ensures that you have backed up the latest state of each database or each file and filegroup.
In case of a system database, a full backup ensures that the restored databases are backed up at the most recent point-in-time.
These backup conversion settings are enabled by default.
If you do not want to convert your backups under the predefined conditions, you can disable the backup conversion settings.
For steps to disable the backup conversion settings, see Disabling Conversion of Log Backup to Differential Backup.
Note: In certain circumstances, a non-full backup is automatically converted to a full backup even if the backup conversion settings are disabled. For more information on such scenarios, see Automatic Conversion of Non-Full Backups into Full Backups.