Transaction log truncation for SQL Server

Acronis Backup does not truncate transaction logs after creating a disk-level backup.

If you want to truncate transaction logs, there are two options:

• Switch the databases to the Simple Recovery Model. When using Simple Recovery, you cannot back up the transaction log. Therefore, a database can be recovered only to a point in time of a backup created by Acronis Backup (to be exact, to the moment of taking a snapshot). The backup interval should be short enough to prevent the loss of significant amounts of data.
• Back up transaction logs by using the native backup engine of Microsoft SQL Server. A database can be recovered to any point in time by applying transaction logs after a recovery from a backup created by Acronis Backup.

In both cases, transaction logs will be truncated automatically.

To switch the database to the Simple Recovery Model

1. Run Microsoft SQL Server Management Studio and connect to the instance.
2. Right-click the database, and then click Properties. This will open the Database Properties dialog box.
3. In the Select a page pane, click Options.
4. In the Recovery Model list, click Simple.

To back up transaction logs by using Transact-SQL

Refer to the following article: https://technet.microsoft.com/en-US/library/ms186865(v=sql.90).aspx.