Been having a grand ol’ time with SQL Server 2005 lately.  We were making backup and backups off of a dev database and noticed all of our space was getting eaten up.  Took a look today and realized our transaction logs were 10GB. not good.  We change the restore type to simple and cleared out the transaction log with some help from the link below.

http://stackoverflow.com/questions/40402/what-is-the-command-to-truncate-a-sql-server-log-fil e

make sure to encapsulate the servername in brackets [ ] .