Microsoft SQL Server Transaction Log Settings

The SQL tab applies to VMs that run Microsoft SQL Server and if you have selected Process transaction logs with this job when configuring application-aware processing.

To configure how Veeam Backup & Replication must process transaction logs of an Microsoft SQL Server:

1. At the Guest Processing step of the wizard, click Applications.
2. In the Application-Aware Processing Options list, select a VM that runs the Microsoft SQL Server.
3. Click Edit.
4. In the Processing Settings window, switch to the SQL tab and specify how transaction logs must be processed:

• If you want Veeam Backup & Replication to trigger truncation of transaction logs after the CDP policy creates a long-term restore point, select Truncate logs.

In this case, transaction logs will be truncated after the CDP policy creates a long-term restore point. If the creation fails, the logs will remain untouched until the next start of the long-term restore point creation.

• If you do not want Veeam Backup & Replication to truncate logs at all, select Do not truncate logs.

This option is recommended if you use another tool to perform VM guest-level replication, and this tool maintains consistency of the database state.

To configure transaction log handling for multiple VMs at once, do the following:

1. At the Guest Processing step of the wizard, click Applications.
2. In the Application-Aware Processing Options list, select multiple VMs.
3. Click Edit > Microsoft SQL Server.
4. Configure options described in the previous list.