dangers of using SHRINKFILE in sql server 2008 I'm trying to shrink the file size of a massive log file and was wondering how I estimate the size of the log file and what the dangers in running this are
If you use the full or bulk logged recovery model, 
I advise that you take a look at this post for shrinking the log file. First perform a full database backup as switching the recovery models will break the log chain. Also chose a reasonable initial size for the log file, and generally speaking I use an increment in MB rather than percents.