Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ssrikrish
Yak Posting Veteran
69 Posts |
 Posted - 2006-12-18 : 10:27:54
|
| we were doing migration from sql 2K to sql 2005. we used the backup/restore method. after i restored the sql sk db to 2005, i ran checkdb and there were consistency errors. The error was as follows:Check Catalog Msg 3853, State 1: Attribute (referenced_major_id=1241979701,referenced_minor_id=4) of row (class=0,object_id=467024945,column_id=0,referenced_major_id=1241979701,referenced_minor_id=4) in sys.sql_dependencies does not have a matching row (object_id=1241979701,column_id=4) in sys.columns.Please help. Not sure what the fix is. If i run checkdb on sql 2k, there are no consistency errors. could this be due to hardware issue or is there something that needs to be done before migration? |
|
|
ssrikrish
Yak Posting Veteran
69 Posts |
Posted - 2006-12-26 : 12:53:04
|
| Never mind. I figured out the problem and the solution. Apparently, SQL 2005 looks for dependencies more thoroughly than sql 2k and dropping and recreated outdated dependencies fixed the problem.-- Sri |
 |
|
|
|
|
|
consistency errors