Configuring Backup Conversion Settings for the SQL Server Agent

By default, backup conversion settings are enabled for both the default and database subclients and the file and filegroup subclients.

Log backups performed by software other than Commvault, such as SQL Enterprise Manager, are automatically converted to a full backup. After adding files or filegroups to the database, the next backup is automatically converted to a full backup. Full backups ensure complete data protection. We recommend that you leave the Convert option enabled so that no data is excluded from the backup operation unintentionally.

You can disable backup conversion settings for subclients if you do not want to convert one type of backup to another if, for example, you want to preserve log backups performed by third party software. Disabling the Convert option disables all the backup conversions for the subclient. However, you can disable each conversion setting and allow the other settings to remain in effect.

Procedure

1. From the CommCell Browser, click Client Computers > client > SQL Server > instance.

2. Right-click the default subclient, and then click Properties.

   The Subclient Properties dialog box is displayed.

3. On the Backup Rules tab, configure backup conversions:

   • To enable all conversion settings, select the Convert check box.

   • To disable the conversion of log backup to full backup:

     1. Select the Convert check box.

     2. Select the Do not convert log backups to full if a log backup was performed using other software.

     3. On the SQL Settings tab, select the Disable Log Consistency Check check box.

   • To disable backup compression with Native SQL Compression and disable the conversion of backups to full after adding files or filegroups to a subclient:

     1. Select the Convert check box.

     2. Clear the File or Filegroups are added check box.

4. Click OK.