November 13, 2014 at 7:52 am
I have performed a truncate partition procedures to purge some data, but when I check the disk size it is still the same before the truncate procedure. I checked the db size and it has gone down to 50% and the partition range values that I want is correct. Is there something else I need to do to refresh and show the new disk size? Any help is greatly appreciated. By the way, I'm doing this in a test environment, so I just want to make sure the procedures are ok before I do this in production.
November 13, 2014 at 8:35 am
Truncating a table or deleting data from a table does not release space from to the operating system from the database file(s), if does make that space available for re-use by the database. If you really need to release the space to the operating system you need to do a DBCC SHRINKFILE(). I wouldn't normally recommend that as the database grew to that size due to use and unless no new data is going to be added to the database, it will likely grow back to the size again.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply