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.