Monday, March 25, 2013

Fix: Unable to shrink file

You've cleared DB connections, CHECKPOINTed, took a backup, but still can't shrink a file.

Grow the file slightly, even just 1 MB.

Then try the shrink again.

Here's a script you can use: http://www.sqlservercentral.com/Forums/Topic647662-5-1.aspx#bm648809