I have truncated a very large table from our database.
After that was done, I ran a DBCC SHRINKDATABASE and it completed without errors, but no space was reclaimed and the MDF file remained the same size.
I then ran a DBCC SHRINKFILE against the MDF file, and once again it completed without errors, but no space was reclaimed.
Why can't I get back the space that should be there after I truncated a huge table?
Any help or suggestions would be greatly appreciated.
Thank you
After that was done, I ran a DBCC SHRINKDATABASE and it completed without errors, but no space was reclaimed and the MDF file remained the same size.
I then ran a DBCC SHRINKFILE against the MDF file, and once again it completed without errors, but no space was reclaimed.
Why can't I get back the space that should be there after I truncated a huge table?
Any help or suggestions would be greatly appreciated.
Thank you