A follow up note. The truncate_only clause will not work in SQL 2008 but will work in SQL 2005.

>Run the following script:
>
>

>use dbName
>backup log dbName with truncate_only
>
>dbcc shrinkfile (dbName_log, 15)
>

>
>Change 'dbName' to your database name and change '15' to the size you want the log file to be.
>
>HTH
>
>
>>I detached a DB from my client site and emailed it to myself. I then reloaded all the data they had in the before.
>>
>>The logfile ballooned to 300mb. Is there a way to reduce this size?
>>
>>I tried DBCC SHRINKFILE(database) but it had no effect.