September 22, 2003 at 1:45 am
Even after dropping some tables, when we click on the properties of a database in Enterprise manager, the size doesn't seem to reduce.
Can anyone helpout on this. Does dropping of a table increase the space in the db.
Regards,
K. Sripriya
September 22, 2003 at 2:26 am
Dropping a table only increases the amount of free space in the database.
If you want to reduce the amount of allocated space to a database you need to shrink the database. You can right click the database in EM and select shrink database or you can use DBCC SHRINKDATABASE command in Query Analyser.
Jeremy
September 22, 2003 at 3:02 am
Thank you for the reply.
We have executed the DBCC command too.
September 22, 2003 at 3:45 am
To see the size of the DB adjusted run DBCC updateusage. See BOL for script details
HTH
Ray Higdon MCSE, MCDBA, CCNA
------------
Ray Higdon MCSE, MCDBA, CCNA
September 23, 2003 at 8:29 am
You can also do
exec sp_spaceused @updateusage = 'TRUE' to update useage and get the true space in the db.
Then shrink the db to whatever size to recoop the free space.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply