troubleshooting Question

Migrated Integrity Check failing in SQL2005

Avatar of randyrood
randyrood asked on
Microsoft SQL ServerWindows Server 2003Microsoft SQL Server 2005
1 Comment1 Solution1183 ViewsLast Modified:
We have Windows 2003 running on our servers and we upgraded our databases from SQL2000 to SQL2005 two weeks ago.  We migrated all of our maintenance plans at that time.  All seem to work but one: The integrity check.  We deleted the migrated plan and created one from scratch using SQL2005...it still failed.  I have tried researching the error and had no luck...here is the text from the error message:

Executing the query "DBCC CHECKDB WITH NO_INFOMSGS" failed with the following error:
"Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=302624121,referenced_minor_id=1)
      of row (class=0,object_id=173295727,column_id=0,referenced_major_id=302624121,referenced_minor_id=1)
      in sys.sql_dependencies does not have a matching row (object_id=302624121,column_id=1) in sys.columns.
 Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=302624121,referenced_minor_id=1)
      of row (class=0,object_id=292912115,column_id=0,referenced_major_id=302624121,referenced_minor_id=1)
      in sys.sql_dependencies does not have a matching row (object_id=302624121,column_id=1) in sys.columns.
 Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=302624121,referenced_minor_id=1)
      of row (class=0,object_id=308912172,column_id=0,referenced_major_id=302624121,referenced_minor_id=1)
      in sys.sql_dependencies does not have a matching row (object_id=302624121,column_id=1) in sys.columns.
 Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=302624121,referenced_minor_id=1)
      of row (class=0,object_id=1778821399,column_id=0,referenced_major_id=302624121,referenced_minor_id=1)
      in sys.sql_dependencies does not have a matching row (object_id=302624121,column_id=1) in sys.columns.
 Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=786153896,referenced_minor_id=1)
      of row (class=0,object_id=173295727,column_id=0,referenced_major_id=786153896,referenced_minor_id=1)
      in sys.sql_dependencies does not have a matching row (object_id=786153896,column_id=1) in sys.columns.
 Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1052582838,referenced_minor_id=4)
      of row (class=0,object_id=173295727,column_id=0,referenced_major_id=1052582838,referenced_minor_id=4)
      in sys.sql_dependencies does not have a matching row (object_id=1052582838,column_id=4) in sys.columns.
 Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1316251794,referenced_minor_id=12)
      of row (class=0,object_id=173295727,column_id=0,referenced_major_id=1316251794,referenced_minor_id=12)
      in sys.sql_dependencies does not have a matching row (object_id=1316251794,column_id=12) in sys.columns.
 Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1316251794,referenced_minor_id=66)
      of row (class=0,object_id=173295727,column_id=0,referenced_major_id=1316251794,referenced_minor_id=66)
      in sys.sql_dependencies does not have a matching row (object_id=1316251794,column_id=66) in sys.columns.
 Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1588252763,referenced_minor_id=2)
      of row (class=0,object_id=173295727,column_id=0,referenced_major_id=1588252763,referenced_minor_id=2)
      in sys.sql_dependencies does not have a matching row (object_id=1588252763,column_id=2) in sys.columns.

CHECKDB found 0 allocation errors and 9 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 9 consistency errors in database 'Comfort'.".

Possible failure reasons:
Problems with the query,
"ResultSet" property not set correctly,
parameters not set correctly,
or connection not established correctly.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros