SQL Server Performance

About 8905 and 8906 errors

Discussion in 'Contribute Your Performance and Clustering Tips' started by Luis Martin, Oct 19, 2003.

  1. Luis Martin Moderator

    If you have the following error:

    Server: Msg 8905, Level 16, State 1, Line 0
    Extent (1:2388896) in database ID 7 is marked allocated in the GAM, but no SGAM or IAM has allocated it.

    and have SQL7, even with SP4, the

    DBCC DBCHECK (Database, REPAIR_ALLOW_DATA_LOSS)

    show n errors found and n errors fixed.

    Well, message is wrong (Found in Microsoft)

    Only way to fix are:

    With SQL7: Use DTS to create a new database.[:0]

    Or, install SQL2000 with SP2 minimun,[:0] and run again,

    DBCC DBCHECK (Database, REPAIR_ALLOW_DATA_LOSS)



    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell
  2. satya Moderator

    For any such errors about database consistency its always suggested to test and apply the latest service pack.

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  3. Luis Martin Moderator

    What I did was:
    Install SP4 and did not work.
    Use SQL2000 with SP2 (not in client site) and database was fixed.
    What is difficult to believe is the following.
    Client has SQL7 sp4 so he has 1 solution: spend money.
    Database is big, so with actual SQL must have more disk.
    Or change to SQL2000 Sp2, whats means spend money anyway


    Luis Martin

    ...Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
    Bertrand Russell

Share This Page