Post reply

DBCC shrinkfile error - Msg 8985

  • May 24, 2013 at 5:16 am

    #1618184

    Please note: 9 year old thread.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 5, 2015 at 5:54 am

    #1788800

    Nicholas Cain (4/14/2004)

    Try shrinking it using the fileid (SELECT NAME, FILEID FROM SYSFILES), use the same syntax, just replace the filename with the fileid.

    Just want 2 thank u cause that fixed my issue with 1 of the db`s although the error msg was in sys.database_files & I found some Indexes corruption, even after REPAIR_REBUILD, could not fix the shrink_log file issue till I googled it and found your solution, so thanx again.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • April 5, 2015 at 5:56 am

    #1788801

    GilaMonster (5/24/2013)

    Please note: 9 year old thread.

    Now it`s even 11 years old thread, but amazingly still very useful to fix the current issues, seems that MS will never ran out of bugs 🙂

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

Viewing 3 posts - 16 through 17 (of 17 total)

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