25112
asked on
rebuild does not fix NC index error
my understanding is NC index can be easily fixed in data corruption.. but what may block easy rebuild of such a case?
ASKER
The funny thing is if I run DBCC CHECKTABLE (OptionsReview) then I get the below:
DBCC results for 'OptionsReview'.
There are 217112 rows in 2332 pages for object "OptionsReview".
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
but
DBCC CHECKDB (POPT) WITH NO_INFOMSGS, ALL_ERRORMSGS
brings back the same errors for this table.
DBCC results for 'OptionsReview'.
There are 217112 rows in 2332 pages for object "OptionsReview".
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
but
DBCC CHECKDB (POPT) WITH NO_INFOMSGS, ALL_ERRORMSGS
brings back the same errors for this table.
ASKER
i dropped the index and then there is no errors with
DBCC CHECKDB (POPT) WITH NO_INFOMSGS, ALL_ERRORMSGS for that table..
but i recreate that index, then i get the error back.
does that mean the problem is data and not index even though the error message seems to indicate so? what would you recommend for this?
DBCC CHECKDB (POPT) WITH NO_INFOMSGS, ALL_ERRORMSGS for that table..
but i recreate that index, then i get the error back.
does that mean the problem is data and not index even though the error message seems to indicate so? what would you recommend for this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
100% Right on..thanks Scott..
create CI once did it.
create CI once did it.
ASKER
Msg 8955, Level 16, State 1, Line 2
Data row (1:98012:58) identified by (HEAP RID = (1:98012:58)) with index values 'OptionsReviewID = 4146 and HEAP RID = (1:98012:58)'.
NdxOptionsReviewA is a non-clustered non-unique index on OptionsReviewID.
I rebuilt the index NdxOptionsReviewA, but I still get the same error when I run dbcc checkdb or checktable.