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
No comments:
Post a Comment