Server: Msg 8905 (Extect allocated in the GAM)

• kamitf

  SSC Journeyman

  Points: 80

  More actions

  May 4, 2004 at 8:03 am

  #85499

  I get this error after runing dbcc check db:

   

  Server: Msg 8905, Level 16, State 1, Line 1

  Extent (1:681848) in database ID 7 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

  Even dbcc check with repair_allow_data_loss did not help me.

  Any Ideas?

  Thanks

• May 7, 2004 at 8:00 am

  This was removed by the editor as SPAM

• mbgentle

  SSC Veteran

  Points: 242

  More actions

  May 10, 2004 at 1:31 pm

  #505866

  Is this SQL 2000?

  Maybe this link will help

  http://support.microsoft.com/default.aspx?scid=kb;en-us;308795

  
  mbg

• jdelrio

  Valued Member

  Points: 60

  More actions

  May 16, 2005 at 3:04 pm

  #559130

  I have the same error, but in SQL 7.0 and I don't know what can do.