• Do a DBCC SHRINKFILE or from SSMS -> right click the Database -> Tasks -> Shrink - >File (check for available free space - if this is 90% or higher you can definitely shrink the file if in simple recivery mode)and click ok. OR you can specify a shrink file size in the shrink action, you can also get the TSQL for shrink operation..if you click on the SCRIPT Drop Down on TOP of the window.