Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error with DBCC CHECKDB Expand / Collapse
Author
Message
Posted Saturday, August 4, 2012 1:12 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, November 14, 2014 12:41 AM
Points: 104, Visits: 410
I am getting error while executing DBCC CHECKDB on one database that shows

CHECKDB found 0 allocation errors and 1 consistency errors in database 'My_Usage'.
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (My_Usage).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.


Msg 8951, Level 16, State 1, Line 1
Table error: table 'Marketing_Person'(ID 010). Data row does not have a matching index row in the index 'IX_CUSTOM_01832193'(ID 2). Possible missing or invalid keys for the index row matching:
Msg 8955, Level 16, State 1, Line 1


Can any one please suggest me how to proceed to fix this issue....

Thanks in Advance
Post #1340211
Posted Monday, August 6, 2012 2:57 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 4:10 AM
Points: 5,221, Visits: 5,119
Drop and recreate the index, would be the quickest solution.



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1340421
Posted Monday, August 6, 2012 4:22 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 4, 2014 12:10 AM
Points: 18, Visits: 162
DBCC CHECKDB ('DBName', REPAIR_REBUILD) WITH ALL_ERRORMSGS
Post #1340497
Posted Monday, August 6, 2012 4:25 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 4:10 AM
Points: 5,221, Visits: 5,119
rahul.rahuzz (8/6/2012)
DBCC CHECKDB ('DBName', REPAIR_REBUILD) WITH ALL_ERRORMSGS


Only use REPAIR.... options as a last resort, drop and recreate of the index would be the prefered option IMHO.


Important note

Use the REPAIR options only as a last resort. To repair errors, we recommend restoring from a backup. Repair operations do not consider any of the constraints that may exist on or between tables. If the specified table is involved in one or more constraints, we recommend running DBCC CHECKCONSTRAINTS after a repair operation. If you must use REPAIR, run DBCC CHECKDB without a repair option to find the repair level to use. If you use the REPAIR_ALLOW_DATA_LOSS level, we recommend that you back up the database before you run DBCC CHECKDB with this option.

http://msdn.microsoft.com/en-us/library/ms176064.aspx




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1340498
Posted Monday, August 6, 2012 11:53 PM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 4, 2014 12:10 AM
Points: 18, Visits: 162
I will still recommend for Repair_rebuild as it repairs extra keys in nonclustered indexes + rebuilds indexes and NO DATA LOSS..
Post #1341017
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse