Post reply

Fail Check integrity DB

  • March 3, 2010 at 1:24 am

    #217354

    Hi mates!

    I have a SQL Server 2008 and MOSS 2007. I hava schedule job, that run the integrity the Databases. In the DB WSS_Mysityes always day print this error:

    Msg 8909, Sev 16, State 1, Line 1 : Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type Unknown), page ID (1:2558) contains an incorrect page ID in its page header. The PageId in the page header = (0:0). [SQLSTATE 42000]

    Msg 8928, Sev 16, State 1, Line 1 : Object ID 85575343, index ID 1, partition ID 72057594039042048, alloc unit ID 72057594040090624 (type In-row data): Page (1:2558) could not be processed. See other errors for details. [SQLSTATE 42000]

    Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'WSS_MySites'. [SQLSTATE 01000]

    Msg 8954, Sev 16, State 1, Line 1 : CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object. [SQLSTATE 01000]

    Msg 8990, Sev 16, State 1, Line 1 : CHECKDB found 0 allocation errors and 1 consistency errors in table 'AllDocs' (object ID 85575343). [SQLSTATE 01000]

    Msg 8989, Sev 16, State 1, Line 1 : CHECKDB found 0 allocation errors and 2 consistency errors in database 'WSS_MySites'. [SQLSTATE 01000]

    Msg 8958, Sev 16, State 1, Line 1 : repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (WSS_MySites). [SQLSTATE 01000]

    Msg 2528, Sev 16, State 1, Line 1 : DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000]

    Job 'Check Integrity BD' : Step 6, 'Checkear WSS_SSPAdmin' : Began Executing 2010-03-01 06:03:12

    I passed repair_rebuild in this DB, but the consistency error is present. I need help. That suggestion??

    Very Thanks people!!

  • March 3, 2010 at 6:00 am

    #1127689

    Repair_rebuild will do nothing, seeing as the minimum level to repair is repair_allow_data_loss.

    I strongly suggest that you get out a clean backup and restore. Especially seeing as this is sharepoint, I don't know how much damage a checkDB repair will do, but I can imagine it could be a lot.

    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

  • March 3, 2010 at 7:04 am

    #1127744

    OK, thanks Gila

Viewing 3 posts - 1 through 3 (of 3 total)

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