IDCSSupport
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
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]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER