Issue

Backups are completing successfully, but SQL logs aren’t truncating.

Steps to resolve

The truncating of logs isn’t something that the CFA has control over.

The CFA 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. The CFA doesn’t 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. However, this is beyond the scope of the CFA.

Please keep in mind that truncation doesn’t 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.