Post reply

Msg 8928, Level 16, State 1, Line 9

  • January 5, 2011 at 4:19 am

    #243049

    Hi dear freinds,

    Please help me. Today i got an error message while running dbcc checkdb on one of my database.

    Error message:

    Msg 8928, Level 16, State 1, Line 9

    Object ID 2073058421, index ID 0, partition ID 72057594038321152, alloc unit ID 72057594042318848 (type In-row data): Page (1:143) could not be processed. See other errors for details.

    Msg 8939, Level 16, State 98, Line 9

    Table error: Object ID 2073058421, index ID 0, partition ID 72057594038321152, alloc unit ID 72057594042318848 (type In-row data), page (1:143). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 12716041 and -4.

    How i can solve this problem? pls help me out.

    Thanks in advance.

    M.I.

    ________________________________________
    M.I.
    [font="Times New Roman"]

    Learning is a path with no destination...
    [/font]

  • January 5, 2011 at 5:29 am

    #1269418

    You have database corruption, at least one page is damaged and not readable.

    That's not the full output of checkDB, please run the following and post the full and complete output.

    DBCC CheckDB(<Database name>) WITH No_INFOMSGS, ALL_ERRORMSGS

    Do you have a clean backup of this database? (One without the corruption)? What recovery model is the database running in?

    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

  • January 5, 2011 at 5:47 am

    #1269423

    Yep your DB has spat it.

    As Gila said: have you got backups? (good ones). Because you'll be looking to restore it if possible.

    also:

    - what is the role of DB? Dev/Test/OAT/Prod?

    Carlton.

  • January 5, 2011 at 5:52 am

    #1269428

    Carlton Leach (1/5/2011)

    Because you'll be looking to restore it if possible.

    Maybe. Depends on a number of factors.

    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

  • January 5, 2011 at 6:24 am

    #1269452

    GilaMonster (1/5/2011)

    Carlton Leach (1/5/2011)

    Because you'll be looking to restore it if possible.

    Maybe. Depends on a number of factors.

    Agreed, should have included the word 'generally' or 'probably'

  • January 5, 2011 at 6:41 am

    #1269460

    its my producation server i restored my database. Now its working fine.

    Thank you very much Gail and Carlton.

    ________________________________________
    M.I.
    [font="Times New Roman"]

    Learning is a path with no destination...
    [/font]

Viewing 6 posts - 1 through 5 (of 5 total)

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