September 9, 2010 at 4:39 am
hello experts,
i am having a database size is 28 gb, it was having a table in which a column was around 10 gb, i copied that column to a sepatare table by select into statment then database size goes to 38 gb, after that i droped that column(10 gb) which was in previous table, bt size of database is still 38 gb.
while i did the same thing in my test server there was size got reduced to the previous size,
why is this so?? pls help??
September 9, 2010 at 4:41 am
Try rebuilding your clustered index on the table, that should help.
-- Gianluca Sartori
September 9, 2010 at 7:55 am
perhaps the test database had "auto shrink" on... or maybe the recovery mode was set to simple (which sort of "auto shrinks" the log).
If you need to recover the space look at DBCC SHRINKFILE.
The probability of survival is inversely proportional to the angle of arrival.
September 9, 2010 at 12:42 pm
Also, and you may know this, but there is a difference between total space and used space. The comments others have posted are suggesting that some of the free space may have been reclaimed because the test database was on auto shrink.
For a quick query on total space and used space related to the data files you can run DBCC ShowFileStats
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply