July 17, 2009 at 10:18 pm
Hi Team,
My integrity job is failing with the below error messge. error message as follows:
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3077
Report was generated on "BSVRXY".
Maintenance Plan: All Integrity Check
Duration: 00:10:38
Status: Warning: One or more tasks failed..
Details:
Check Database Integrity Task (BSVRSY)
Check Database integrity on Local server connection
Databases that have a compatibility level of 70 (SQL Server version 7.0) will be skipped.
Databases: All user databases
Include indexes
Task start: 2009-07-17T19:50:24.
Task end: 2009-07-17T20:00:49.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "Table error: table 'EV001_MSTR_DATE_SCHED' (ID 670625432). Data row does not have a matching index row in the index 'EV001_BY_CENT_DATE' (ID 2). Possible missing or invalid keys for the index row matching:
Data row (1:638185:69) identified by (HEAP RID = (1:638185:69)) with index values 'EV001_CENTURY_DATE = 1260427 and HEAP RID = (1:638185:69)'.
Table error: table 'EV001_MSTR_DATE_SCHED' (ID 670625432). Data row does not have a matching index row in the index 'EV001_BY_CENT_DATE' (ID 2). Possible missing or invalid keys for the index row matching:
Data row (1:638191:44) identified by (HEAP RID = (1:638191:44)) with index values 'EV001_CENTURY_DATE = 921115 and HEAP RID = (1:638191:44)'.
Object ID 1086626914, forwarded row page (1:233191), slot 4 should be pointed to by forwarding row page (1:361778), slot 7. Did not encounter forwarding row. Possible allocation error.
Object ID 1086626914, forwarded row page (1:477167), slot 3 should be pointed to by forwarding row page (1:361778), slot 0. Did not encounter forwarding row. Possible allocation error.
Object ID 1086626914, forwarded row page (1:484936), slot 4 should be pointed to by forwarding row page (1:361779), slot 2. Did not encounter forwarding row. Possible allocation error.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'EV001_MSTR_DATE_SCHED' (object ID 670625432).
CHECKDB found 0 allocation errors and 3 consistency errors in table 'EV200_EVENT_MASTER' (object ID 1086626914).
CHECKDB found 0 allocation errors and 5 consistency errors in database 'usiprddb'.
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (usiprddb).". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Does anbody have enconutered this before?
Please help..
Regards,
Atul
July 18, 2009 at 6:00 am
Take the database into single user mode and run CheckDB with the repair_rebuild option.
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
July 18, 2009 at 6:58 am
Hi,
I have manually rebuild both the indexes (as per the error message two indexes need rebuild) and i have rerun the job, still its failing with the same error message. do its necessary to bring the whole DB in single user mode and rebuild.
Please let me know, as its a production database.
July 18, 2009 at 8:37 am
Take the database into single user mode and run CheckDB with the repair_rebuild option. Sometimes manually dropping and recreating the indexes is sufficient (note, dropping and recreating, not rebuilding), sometimes not.
Running checkDB with a repair option will take at least as long as the integrity check takes, possibly longer. The DB has to be in single user mode to do so. You'll have to do this in a maintenance window.
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
July 19, 2009 at 11:33 am
Hi,
Thanks for the info, i will take an outage and try to solve it
Thanks,
Atul
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply