Microsoft SQL Server logs do not purge or truncate

On this page

Issue

Backups are completing successfully, but Microsoft SQL Server logs are not truncating.

Steps to resolve

The truncating of logs is not something that the Backup & Disaster Recovery appliance has control over.

Appliance tells the SQL server to back up certain directories or files and asks for that data. Log truncation is a function of the SQL engine itself. Appliance does not explicitly truncate (or not truncate) logs at any time. The rules governing truncation during backup should be followed normally, as expected.

Many things can affect SQL log truncation. Please be aware of database “recovery modes” and how they can affect log truncation, but this is beyond the scope of appliance.

Please keep in mind that truncation does not reduce the size of a physical log file. Reducing the physical size of a log file requires shrinking the file. For information about shrinking the size of the physical log file, see Shrinking the Transaction Log.