Microsoft SQL Server 事务日志设置

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.