Following those steps will first empty the transaction log and then shrink the file size

use master
go
dump transaction with no_log
go
use
go
DBCC SHRINKFILE (, 100) — where 100 is the size you may want to shrink it to in MB, change it to your needs
go
— then you can call to check that all went fine
dbcc checkdb()

Today’s Clips Include: Entertainment News… Arrests for Outstanding Parking Tickets… Bizarre File… 2009 Grammy’s Recap… Ultrasounds… Greg Grunberg from Heroes on the Phone… Boxing…

Amazon + Apple… why should I want a Kindle vs. an iPod touch.. I mean, aren’t these two technologies on a collision course?

I’ve gotta get the kids play doh fun factory and make these… http://is.gd/iUw3

Just finished directing a double S’more service today. FTW! Http://YouTube.com/smorekids