Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Shrink Does Not Work

Status
Not open for further replies.

bksqlman

Programmer
Sep 28, 2005
2
US
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
 
Try changing the recovery model to simple before running the truncate and then back to whatever it was.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top