shrink fails with error - File ID of database ID cannot be shrunk as it is either being shrunk by another process or is empty

  • Great! It's work!;-)

  • Ted Henderson (3/16/2010)


    One more thing to try that worked for me when I received this error message. I just increased the data file by a few MB and then tryed to do the Shrink again. It worked fine. It seems like adding a few MB to the data file resets an internal counter or switch that tells it it's not in the middle of a shrink now.

    This is what finally did it for me! Thanks!

  • I had a same and tried as you mentioned steps,it worked for me

  • Thank you, Ted! It worked

Viewing 4 posts - 31 through 33 (of 33 total)

You must be logged in to reply to this topic. Login to reply