Automating Database Transaction Log Truncation

It is possible to implement transaction log backups which automatically truncate the transaction log, without any user intervention.

The following link to Microsoft's SQL Server documentation describes how to implement transaction log backups, which will automatically truncate the transaction log without user intervention.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#E4AA