Friday, October 22, 2010 1:31 PM
Hello all !
I have a susdb.mdf file 55 GB size.
How do I reduce the size of the db ?
Windows 2003 Server with SQL server 2005
Friday, October 22, 2010 1:52 PM
You can use DBCC SHRINKFILE, however running it is generally not a good idea if you are going to need that space again in the near future. Shrinking is a bad idea for performance reasons because of the fragmentation it causes, plus when the file has to expand you take a big hit. If you are sure that your database file will not grow such huge in near future
using managemet studio
or T SQL
Also, a must read on the subject
Friday, August 10, 2012 1:54 PM