use Northwind go dbcc shrinkfile (Northwind_log,EMPTYFILE) checkpoint go dbcc shrinkdatabase (Northwind) go