The Multifunctioning DBA

May 21 2012   4:25PM GMT

Strange Error when shrinking db file



Posted by: Colin Smith
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

Leave a comment: