| Author |
Topic |
|
CanadaDBA
583 Posts |
Posted - 2008-07-08 : 10:50:15
|
| DBCC CHECKCATALOG returns a set of rows like the following. Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=68247348,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1What it means and what should I do?I ran DBCC CHECKDB and it found 0 allocation errors and 62 consistency errors in the database.Canada DBA |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-08 : 11:35:56
|
| Looks like system table is corrupted. Do you have good backups?Also post in Data corruption Forum. Paul can help you. |
 |
|
|
maninder
Posting Yak Master
100 Posts |
Posted - 2008-07-08 : 14:26:07
|
| Can you also run this pl. and post the resutls.PAUL is the DBCC GURU.. Check him out as sodeep suggested.DBCC CHECKDB (DatabaseName) WITH NO_INFOMSGS, ALL_ERRORMSGSManinderSQL server Architect / Admin (DEV&PROD) |
 |
|
|
CanadaDBA
583 Posts |
Posted - 2008-07-10 : 14:11:19
|
| DBCC CHECKDB (DatabaseName) WITH NO_INFOMSGS, ALL_ERRORMSGSMsg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=68247348,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=160771680,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=224771908,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=356248374,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=372248431,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=388248488,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=404248545,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=420248602,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=436248659,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=452248716,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=468248773,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=484248830,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=500248887,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=516248944,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=532249001,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=548249058,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=564249115,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=580249172,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=596249229,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=612249286,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1076250939,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1204251395,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1284251680,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1316251794,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1332251851,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1348251908,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1428252193,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1460252307,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1476252364,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1492252421,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1524252535,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1604252820,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=1620252877,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=933578364,referenced_minor_id=2) of row (class=0,object_id=2119730654,column_id=0,referenced_major_id=933578364,referenced_minor_id=2) in sys.sql_dependencies does not have a matching row (object_id=933578364,column_id=2) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=224771908,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=356248374,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=372248431,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=388248488,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=404248545,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=420248602,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=436248659,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=452248716,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=468248773,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=484248830,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=500248887,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=516248944,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=532249001,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=548249058,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=564249115,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=580249172,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=596249229,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=612249286,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1076250939,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1268251623,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1284251680,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1316251794,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1396252079,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1460252307,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1604252820,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1090818948,referenced_minor_id=3) of row (class=0,object_id=1620252877,column_id=0,referenced_major_id=1090818948,referenced_minor_id=3) in sys.sql_dependencies does not have a matching row (object_id=1090818948,column_id=3) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1451152215,referenced_minor_id=8) of row (class=0,object_id=1316251794,column_id=0,referenced_major_id=1451152215,referenced_minor_id=8) in sys.sql_dependencies does not have a matching row (object_id=1451152215,column_id=8) in sys.columns.Msg 8992, Level 16, State 1, Line 1Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1451152215,referenced_minor_id=8) of row (class=0,object_id=1284251680,column_id=0,referenced_major_id=1451152215,referenced_minor_id=8) in sys.sql_dependencies does not have a matching row (object_id=1451152215,column_id=8) in sys.columns.CHECKDB found 0 allocation errors and 62 consistency errors not associated with any single object.CHECKDB found 0 allocation errors and 62 consistency errors in database 'HRPRO'.Canada DBA |
 |
|
|
|
|
|