If the database is running using the full recovery model, the database transaction log should be backed up on a regular basis. Failure to back up the transaction log can cause the log file to consume all available hard drive space. The transaction log backups can be performed as frequently as necessary; frequency is contingent on the recovery needs of the organization.
The database transaction log is truncated automatically in SQL Server when a database is running in Simple Recovery model.