July 21, 2011 at 9:50 am
I have a huge database of size 250GB but i want to reduce the size of the database, have deleted millions of records from the databse expected huge size gain but i see hardly 4gb space gain so far. I would like know the steps to be followed to reduce db size and gain disk space after deleting the transactional records from the huge tables.
July 21, 2011 at 9:59 am
A database isn't an Excel file. It doesn't size itself according to the data. Sizes are pre-set, and should be managed.
If you have deleted data, and don't need the space, you can issue a DBCC SHRINKFILE to shrink specific files. Note that this does cause fragmentation, so you don't shrink all the way down to the data size. Shrink down to a size that allows for some amount of data growth over the next 3-6 months as well as space for maintenance operations, such as index rebuilds.
Note that after a shrink, you do need to run an index rebuild to clean up the fragmentation.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply