Post reply

logical consistency-based I/O error

  • January 30, 2013 at 3:31 am

    #269847

    Hello,

    when i want to see properties of one data base ,or run maitenancetools or backup sqlserver give me this error ,what should i do ?

    SQL Server detected a l: incorrect checksum

    (expected: 0xb20c18d5; actual: 0xb29b4f3b). It occurred during a read of page

    (1:698) in database ID 4 at offset 0x00000000574000 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. (Microsoft SQL Server, Error: 824)

  • January 30, 2013 at 3:43 am

    #1582540

    Run DBCC CHECKDB WITH ALL_ERRORMSGS ; and post result here

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • January 30, 2013 at 6:43 am

    #1582587

    Please run the following (not the statement given previously) and post the full, complete and unedited output.

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

    Do you have a clean backup? (a backup from before the corruption occurred)

    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 30, 2013 at 10:15 pm

    #1582764

    command :

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

    only give error on msdb with below error :

    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 29493257 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 29493257 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 29493257 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 29493257 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).

  • January 31, 2013 at 1:52 am

    #1582800

    Got a backup of MSDB from before the corruption occurred?

    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 31, 2013 at 1:56 am

    #1582803

    No,i have no backup of MSDB before this issue!!

  • January 31, 2013 at 2:05 am

    #1582807

    Then I hope you don't need your backup, maintenance plan and job history...

    Stop SQL Agent

    Set the DB into single user mode

    Run CheckDB with the repair_allow_data_loss option. You will lose data from a bunch of tables.

    Do some root cause analysis. Corruption doesn't just happen, something's wrong somewhere in the IO subsystem

    Fix your backup strategy!

    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 31, 2013 at 2:51 am

    #1582834

    i have one question , does running this command causing damaged for MSSQLServer ? is is safe for run ?

  • January 31, 2013 at 3:30 am

    #1582850

    It will lose data in the msdb database, potentially quite a bit of data. But since you have no backups, you don't really have an alternative.

    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 2, 2013 at 1:25 am

    #1583640

    Hello ,thanks for you'r help.

    i describe condition first for you:

    most important things for me is correcting maintenance plan of MSSQL SERVER,

    delete current job and maitenance plan is not important i will configure them later.

    but important thing for me is this :dose MSSQL server servicr work fine after running that command ? dose command after running force me to install new MSSQL onserver ?

  • February 2, 2013 at 1:33 am

    #1583641

    It repairs the database, nothing more. Go read up on it in Books Online (clearly documented)

    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 4, 2013 at 12:40 am

    #1583810

    hello,when i want to run script ,it need to change data base to single mode.

    when i want to open properties of data base a error message appear ,how i can change data base mode ?

  • February 4, 2013 at 1:51 am

    #1583839

    Stop SQL agent.

    ALTER DATABASE msdb SET Single_User WITH ROLLBACK IMMEDIATE

    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 4, 2013 at 2:12 am

    #1583851

    and how i can change it to multi user mode ?

  • February 4, 2013 at 2:19 am

    #1583855

    ALTER DATABASE msdb SET MULTI_USER

    http://sqldbpool.com/2010/12/18/different-types-of-sql-server-database-access-mode/ - Remember google is your friend.

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

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