sp_helpdb Northwind USE Northwind --Shrink first one DBCC SHRINKFILE ( 'Northwind', 1) --Shrink second one DBCC SHRINKFILE ( 'Northwind_log', 1) --etc