The Multifunctioning DBA

May 21 2012   4:25PM GMT

Strange Error when shrinking db file

Colin Smith Colin Smith Profile: Colin Smith

So I almost never say that you should shrink but sometimes you have to. I ran into such a situation recently and I continued to get this error when changing the initial size of the file.

File ID 2 of database ID 13 cannot be shrunk as it is either being shrunk by another process or is empty.

I checked and it was not being shrunk by anyone else and I know for a fact that it is not empty. So to google I went and I found this site that led me to the right path for resolution. Simple enough resolution since I did not really have the option of detaching and attaching the database. So I did as the blog author suggested and I increased the initial file size by 1 MB and then I was able to shrink it down. How that helps and thanks to Pradeep Adiga for having this solution blogged.

 Comment on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: