Symptoms:

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

Resolution:

The truncating of logs is not 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 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](http://msdn.microsoft.com/en-us/library/ms189275.aspx){:target=\_blank}. However, this is beyond the scope of the CFA.

Please keep in mind that truncation [does not reduce the size of a physical log file](http://technet.microsoft.com/en-us/library/ms189085.aspx){:target=\_blank}. 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.