How to reduce the database size based on MS SQL/Oracle?

[Former Member]

Hi,

I had deleted severy clients via SCC5, but the database size is more and more bigger. Do you know how to reduce the database size.

my platform is: NT, MS SQL 2005

NT, Oracle 10.2

Best Regards,

Simon Shen

[JPReyes · Accepted solution]

Hi Simon,

In the case of SQL you need to check how many space free you have in your datafiles and the based on that you need to Shrink them using DBCC SHRINKFILE command.

Find a couple of reference docs here,

http://www.intermedia.net/support/kb/default.asp?id=996

http://doc.ddart.net/mssql/sql70/dbcc_21.htm

Also i'm pretty sure that if your check the properties of the datafiles in MSSQL Enterprise Manager you get a "Shrink" option.

Regards

Juan

Please reward with points if helpful