Home Forums SQL Server 2005 Administering shrink fails with error - File ID of database ID cannot be shrunk as it is either being shrunk by another process or is empty RE: shrink fails with error - File ID of database ID cannot be shrunk as it is either being shrunk by another process or is empty

  • March 22, 2011 at 5:58 am

    #1301815

    More often than not, the best thing to do is to not shrink at all though.

    Kind regards,

    Vegard Hagen
    Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
    @vegard_hagen on Twitter
    Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)

    It is better to light a candle than to curse the darkness. (Chinese proverb)