Can someone try explain to me why the log file gets filled up so quickly? Our training database is 12gb, but gets little user usage. The transaction log file is around 20mb at the moment. For some reason every now and then the log file is up to 12gb and then backup tran log fails due to disk space errors. I have to manually truncate and log and shrink it. What are the potential problems and how can I solve this? Thanks.