Link to home
Start Free TrialLog in
Avatar of IDCSSupport
IDCSSupportFlag for United States of America

asked on

DBCC CHECKDB gets error Msg 8990

We run weekly DBCC's to test our databases and have started to get 8990 errors on two small tables. See the code sample below I want to eliminate the erros but I'm not sure of the best way to do so.

Thanks,

Andy
sg 2536, Sev 16, State 1, Line 1 : DBCC results for 'Code_Conversion'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 1309 rows in 9 pages for object "Code_Conversion". [SQLSTATE 01000]
Msg 8990, Sev 16, State 1, Line 1 : CHECKDB found 0 allocation errors and 1 consistency errors in table 'Code_Conversion' (object ID 1650104919). [SQLSTATE 01000]
 
Msg 2536, Sev 16, State 1, Line 1 : DBCC results for 'Company_Location'. [SQLSTATE 01000]
Msg 2593, Sev 16, State 1, Line 1 : There are 3749 rows in 35 pages for object "Company_Location". [SQLSTATE 01000]
Msg 8990, Sev 16, State 1, Line 1 : CHECKDB found 0 allocation errors and 1 consistency errors in table 'Company_Location' (object ID 1954106002). [SQLSTATE 01000]
 
Msg 8989, Sev 16, State 1, Line 1 : CHECKDB found 0 allocation errors and 2 consistency errors in database 'Lease'. [SQLSTATE 01000]

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of IDCSSupport

ASKER

Thanks