how to reduce susdb.mdf file size

Question

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

Best Regards,

GadgetPC

Answer 1

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

http://technet.microsoft.com/en-us/library/ms190757.aspx

or T SQL

http://technet.microsoft.com/en-us/library/ms189493.aspx

Also, a must read on the subject

http://www.karaszi.com/SQLServer/info_dont_shrink.asp

Answer 2

This might help:

Move susdb.mdf