I've been working quite a bit recently with a database that I have been constantly deleting from and re-adding data for testing an uploader.  The uploader carries out hundreds of SQL statements and as such it has resulted in a rather large log file, which over time would get to the unmanageable size.
 
 So I had a quick look for ways to reduce the log file size when I want to...  In the end it's simple Smile
 
  DBCC SHRINKDATABASE(<database name>)
 
Simply put in the name of the database and execute it.  Here's a link for more information on the SHRINKDATABASE command