A transaction log that keeps growing: the SIMPLE and FULL recovery models
A log file more than ten times the size of the data file almost always means a database in the FULL recovery model without log backups. How log truncation works, what log_reuse_wait_desc shows and how to bring the .ldf file back to a sensible size in one go.