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.