Excellent article about transaction logs in SQL. My best tip: Always backup the transaction log and clear unused entries. If your log hasn't been backed up before, back it up twice to be able to shrink it. Never use the TRUNCATE command. It is much safer to use the backup facility to maintain the log.