In the past I wrote a short article on how to shrink an MS SQL Database.  It seems the method I used is no longer valid in SQL Server 2008.  To be able to shrink the database, you need to first set the database recovery mode to "simple" before you can shrink the database and log file.  After doing so you can then shrink the files.

 I recently had some trouble with some extremely large SQL Server Log Files.  I tried using the normal Shrink File tool but it would not work.  Here is the proper way  for shrinking SQL Server Log files.