DBCC shrinkfile error - Msg 8985

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  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

• Hany Helmy

  SSChampion

  Points: 13921

  More actions

  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

• Hany Helmy

  SSChampion

  Points: 13921

  More actions

  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