• If you go to enterprise manager and right click the database name and go all tasks, shrink database then click on the Files button. You can specify a size to Shrink the file to. Or if you would rather you could use DBCC SHRINKFILE.