0

I came across this issue while troubleshooting a problem that I described in another post, but I thought this deserves a post of its own.

I'm trying to reclaim some unused space in a table. This is the current disk usage report for the table:

Unused Space

This is the current disk usage report for the database: Unused Space

I'm aware that shrinking a database is generally considered bad practice, but I wanted to see what kind of effect it would have in this situation.

I executed this command:

DBCC SHRINKFILE("MyDbFile", 0)

Here is the result of the command:

enter image description here

Now here are the disk usage reports after the shrink:

enter image description here

enter image description here

Why does it seem like the shrink operation had virtually no effect? I have read that this operation can't shrink a database below it's initial size, but the mimimum database size seems to be set to 640 KB.

3

0

Browse other questions tagged or ask your own question.