The Multifunctioning DBA

May 21 2012   4:25PM GMT

Strange Error when shrinking db file



Posted by: Colin Smith
Tags:
Shrink

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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: