Enabling the Conversion of Log Backups to Differential Backups for the SQL Server Agent

By default, databases that have the simple recovery model are skipped during a transaction log backup operation.To enable the conversion of a log backup to a differential backup, follow any one of the following procedures:

• Create the additional setting bSkipTLForSimpleRecoveryModelDB. You can create this additional setting to convert databases in simple recovery model during transaction log backups. These databases are backed up during the next scheduled full or differential backup for that subclient.

• On the SQL Agent Configuration dialog box, select the Allow transaction log backups to be converted for simple recovery model databases check box.

Databases set to the simple recovery model do not support log backup. Converting log backup to differential backup ensures that both logs and data are backed up.

Tip: You can also configure all SQL clients to convert log backup to differential backup by using the command line interface. Run the qcommand execscript command with the SkipTLForSimpleRecoveryModelDB parameter.

Procedure

Set an Additional Setting

1. From the CommCell Browser, expand Client Computers.

2. Right-click the client, and then click Properties.

3. In the Client Properties dialog box, click Advanced.

4. In the Advanced Client Properties dialog box, on the Additional Settings tab, click Add.

5. In the Add Additional Settings dialog box, create the bSkipTLForSimpleRecoveryModelDB setting:

   1. In the Name box, type bSkipTLForSimpleRecoveryModelDB.

   2. In the Category list, select MSSQLAgent.

   3. In the Type list, select INTEGER.

   4. In the Value box, type 0.

   5. Click OK.

6. Click OK to close the Advanced Client Properties dialog box.

7. Click OK to close the Client Properties dialog box.

From the Control Panel

1. On the CommCell Console ribbon, click the Home tab, and then click Control Panel.

2. In the User pane, click SQL iDataAgent.

   The SQL Agent Configuration (SQL Configuration) dialog box appears.

3. On the SQL Configuration tab, select the Allow transaction log backups to be converted for simple recovery model databases check box.

4. Click OK.