Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BlakeK
Starting Member
10 Posts |
 Posted - 2009-05-19 : 11:16:48
|
| 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 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-19 : 11:29:13
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Database%20Shrinking,Shrink,Shrinking |
 |
|
|
|
|
|
Shrink Does Not Work