Post reply

SQLServer Error: 824

  • February 27, 2010 at 2:02 am

    #139134

    Hello , i defined a job (full back up) in sql server 2005 before , 3 monthe ago , it work's correctly before , today give this error when i running job , I install sp3.0 on my MSSQL.

    Message

    [298] SQLServer Error: 824, SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x6056dae7; actual: 0x60acdbe2). It occurred during a read of page (1:660) in database ID 4 at offset 0x00000000528000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\MSDBData.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. [SQLSTATE HY000] (ConnExecuteCachableOp)

    How can i correct it ? would you please help me ?

  • February 27, 2010 at 2:06 am

    #1126029

    Please run the following and post the full and complete output.

    DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Depending how bad this is, it may be necessary to restore from backups. Do you have clean (uncorrupted) backups of this database. For some background info on what's happened take a look at this article. http://www.sqlservercentral.com/articles/65804/

    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

  • February 27, 2010 at 2:21 am

    #1126031

    i run :

    DBCC CHECKDB (MSDBData) WITH NO_INFOMSGS, ALL_ERRORMSGS

    give me the error : the data base doesnt exist ?!?

  • February 27, 2010 at 2:36 am

    #1126033

    MSDBData is the name of the file, not the name of the database. If you query sys.databases, you'll see that database 4 (ID given in the error message) is called MSDB.

    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

  • February 27, 2010 at 2:40 am

    #1126035

    Just to check, you do have backups of MSDB? You have been backing up the system databases?

    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

  • February 27, 2010 at 2:59 am

    #1126038

    yes, i have back up from my data bases

  • February 27, 2010 at 3:15 am

    #1126039

    Good. So what's the output from CheckDB?

    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

  • February 27, 2010 at 3:20 am

    #1126042

    i run that command , give me this message what should i do ?

    Msg 8979, Level 16, State 1, Line 1

    Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Page (1:656) is missing references from parent (unknown) and previous (page (0:0)) nodes. Possible bad root entry in system catalog.

    Msg 8928, Level 16, State 1, Line 1

    Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data): Page (1:660) could not be processed. See other errors for details.

    Msg 8939, Level 16, State 98, Line 1

    Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data), page (1:660). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 130156553 and -4.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Index node page (0:0), slot 0 refers to child page (1:660) and previous child (0:0), but they were not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:661) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:700) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:705) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:712) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:736) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:737) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:738) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:739) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:740) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:741) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:742) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:743) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:850) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:937) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 117575457, index ID 1, partition ID 72057594039369728, alloc unit ID 72057594043367424 (type In-row data). Parent node for page (1:1112) was not encountered.

    CHECKDB found 0 allocation errors and 19 consistency errors in table 'sysjobhistory' (object ID 117575457).

    Msg 8928, Level 16, State 1, Line 1

    Object ID 901578250, index ID 1, partition ID 72057594042187776, alloc unit ID 72057594046447616 (type In-row data): Page (1:620) could not be processed. See other errors for details.

    Msg 8939, Level 16, State 98, Line 1

    Table error: Object ID 901578250, index ID 1, partition ID 72057594042187776, alloc unit ID 72057594046447616 (type In-row data), page (1:620). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 130156553 and -4.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 901578250, index ID 1, partition ID 72057594042187776, alloc unit ID 72057594046447616 (type In-row data). Index node page (1:849), slot 0 refers to child page (1:620) and previous child (0:0), but they were not encountered.

    CHECKDB found 0 allocation errors and 3 consistency errors in table 'sysmaintplan_log' (object ID 901578250).

    Msg 8979, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Page (1:630) is missing references from parent (unknown) and previous (page (0:0)) nodes. Possible bad root entry in system catalog.

    Msg 8928, Level 16, State 1, Line 1

    Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data): Page (1:698) could not be processed. See other errors for details.

    Msg 8939, Level 16, State 98, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data), page (1:698). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 130156553 and -4.

    Msg 8980, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Index node page (0:0), slot 0 refers to child page (1:698) and previous child (0:0), but they were not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:699) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:703) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:710) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:713) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:729) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:732) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:744) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:745) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:746) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:747) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:748) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:749) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:750) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:751) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:792) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:793) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:794) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:795) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:796) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:797) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:798) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:799) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:840) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:841) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:842) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:843) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:844) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:845) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:846) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:847) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:880) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:881) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:882) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:883) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:884) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:885) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:886) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:887) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:928) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:929) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:930) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:931) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:932) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:933) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:934) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:935) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:960) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:961) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:962) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:963) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:964) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:965) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:966) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:967) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1008) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1009) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1010) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1011) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1012) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1013) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1014) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1015) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1040) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1041) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1042) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1043) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1044) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1045) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1046) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1047) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1064) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1065) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1066) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1067) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1068) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1069) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1070) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1104) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1105) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1106) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1107) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1108) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1109) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1110) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:1111) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2016) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2017) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2018) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2019) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2020) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2021) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2022) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2023) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2056) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2057) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2058) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2059) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2060) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2061) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2062) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2063) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2128) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2129) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2130) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2131) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2132) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2133) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2134) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:2135) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3160) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3161) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3162) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3163) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3164) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3165) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3166) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3167) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3192) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3193) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3194) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3195) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3196) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3197) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3198) was not encountered.

    Msg 8977, Level 16, State 1, Line 1

    Table error: Object ID 1954106002, index ID 1, partition ID 72057594043039744, alloc unit ID 72057594047430656 (type In-row data). Parent node for page (1:3199) was not encountered.

    CHECKDB found 0 allocation errors and 129 consistency errors in table 'backupset' (object ID 1954106002).

    Msg 8928, Level 16, State 1, Line 1

    Object ID 2050106344, index ID 1, partition ID 72057594043236352, alloc unit ID 72057594047627264 (type In-row data): Page (1:1072) could not be processed. See other errors for details.

    Msg 8939, Level 16, State 98, Line 1

    Table error: Object ID 2050106344, index ID 1, partition ID 72057594043236352, alloc unit ID 72057594047627264 (type In-row data), page (1:1072). Test (IS_OFF (BUF_IOERR, pBUF->bstat)) failed. Values are 130156553 and -4.

    Msg 8976, Level 16, State 1, Line 1

    Table error: Object ID 2050106344, index ID 1, partition ID 72057594043236352, alloc unit ID 72057594047627264 (type In-row data). Page (1:1072) was not seen in the scan although its parent (1:696) and previous (1:1055) refer to it. Check any previous errors.

    Msg 8978, Level 16, State 1, Line 1

    Table error: Object ID 2050106344, index ID 1, partition ID 72057594043236352, alloc unit ID 72057594047627264 (type In-row data). Page (1:1073) is missing a reference from previous page (1:1072). Possible chain linkage problem.

    CHECKDB found 0 allocation errors and 4 consistency errors in table 'backupfile' (object ID 2050106344).

    CHECKDB found 0 allocation errors and 155 consistency errors in database 'msdb'.

    repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (msdb).

  • February 27, 2010 at 4:06 am

    #1126046

    I strongly suggest that you restore MSDB from backup. You've got some nasty corruption there and repairing the system databases is not generally recommended.

    Restoring MSDB isn't the same as for the user databases, check Books Online (or the MSDN website) for details on how to do that.

    Edit: You should also do some investigation of the IO subsystem. Looks like some pages have been zeroed out, that's typically an IO subsystem problem.

    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

  • February 27, 2010 at 4:29 am

    #1126051

    sorry , i check my back up folder i dont have back up MSDB back up , there is my data base back up and adventure work back up , what should i do now ?

  • February 27, 2010 at 4:59 am

    #1126054

    Be patient a bit please, I want to get a second opinion here.

    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

  • February 27, 2010 at 9:03 pm

    #1126184

    Hello , Please Help me to solve problem

  • February 28, 2010 at 1:06 am

    #1126216

    I'm waiting for a second opinion from an expert on corruption. Please be patient.

    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

  • February 28, 2010 at 9:36 am

    #1126268

    eh.shams (2/27/2010)

    Hello , Please Help me to solve problem

    First off - this is a volunteer forum, not a service you're paying for - so don't hassle people to hurry up and help you with your problem. If you want fast help, call Product Support and pay for someone to help you quickly (although in this case, they won't be able to do anything more to help you).

    Without backups (your fault) you have two options: rebuild msdb and recreate all your SSIS packages, Agent jobs, etc, or run repair. I'd suggest doing the former, as running repair on msdb with corruptions this extensive will have all kinds of strange effects on your Agent jobs, SSIS packages, etc.

    See Is running repair on msdb safe? for some more details.

    Your I/O subsystem caused this problem - you need to find someone who can run diagnostics on it to figure out what's wrong as it will happen again unless corrected. You also need to get a proper backup strategy.

    Thanks

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

  • February 28, 2010 at 9:58 am

    #1126276

    Thank's , if i uninstall MSSQL SERVER 2005 on server and install it again , can it solve problem ?

Viewing 15 posts - 1 through 15 (of 16 total)

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