First off I am not a SQL guy so I really need some assistance. We are running a SBS2003 server with SQL 2005 Premium. One of the databases is around 600MB and the transaction log is 125GB!! I attempted to backup the database but this did not clear the transaction log. I also tried backing up the transaction log but I did not have enough free space to back it up. I'm not sure if backing up the transaction would truncate it anyhow. Can anyone tell me how to get this back down to a normal size and how to prevent this from happening moving forward?