In the SIMPLE recovery model, the log is truncated during a CHECKPOINT, when the SQL Server’s memory cache is written to disk, which happens automatically but can be performed manually.

SQL Server 2005 databases are set to the Full recovery model by default, so you may need to start creating log backups even if you haven’t ran into problems yet.