DBCC CHECKDB

I restore backup from SQL 2000, with no esues when i run DBCC CHECKDB
getting error
Msg 8992, Level 16, State 1, Line 1
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,reference d_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.
Msg 8992, Level 16, State 1, Line 1
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,reference d_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.
Msg 8992, Level 16, State 1, Line 1
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,reference d_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.
Msg 8992, Level 16, State 1, Line 1
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,referenc ed_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.
Msg 8992, Level 16, State 1, Line 1
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,reference d_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.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute
(referenced_major_id=1052582838,referenced_minor_i d=4) of row
(class=0,object_id=173295727,column_id=0,reference d_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.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute
(referenced_major_id=1316251794,referenced_minor_i d=12) of row
(class=0,object_id=173295727,column_id=0,reference d_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.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute
(referenced_major_id=1316251794,referenced_minor_i d=66) of row
(class=0,object_id=173295727,column_id=0,reference d_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.
Msg 8992, Level 16, State 1, Line 1
Check Catalog Msg 3853, State 1: Attribute
(referenced_major_id=1588252763,referenced_minor_i d=2) of row
(class=0,object_id=173295727,column_id=0,reference d_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
'production'.
Any ideas how fix that?
thanks
Data corruption already existed prior to the backup taken. You have to find
the good backup without data corrupted or try to run Checkdb with repair
option.
However, what I can see from the error messages repair may not repair all
the errors. The other way could try to dump all objects to another new
database.
"Viktor" wrote:

> I restore backup from SQL 2000, with no esues when i run DBCC CHECKDB
> getting error
> Msg 8992, Level 16, State 1, Line 1
> 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,reference d_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.
> Msg 8992, Level 16, State 1, Line 1
> 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,reference d_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.
> Msg 8992, Level 16, State 1, Line 1
> 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,reference d_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.
> Msg 8992, Level 16, State 1, Line 1
> 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,referenc ed_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.
> Msg 8992, Level 16, State 1, Line 1
> 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,reference d_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.
> Msg 8992, Level 16, State 1, Line 1
> Check Catalog Msg 3853, State 1: Attribute
> (referenced_major_id=1052582838,referenced_minor_i d=4) of row
> (class=0,object_id=173295727,column_id=0,reference d_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.
> Msg 8992, Level 16, State 1, Line 1
> Check Catalog Msg 3853, State 1: Attribute
> (referenced_major_id=1316251794,referenced_minor_i d=12) of row
> (class=0,object_id=173295727,column_id=0,reference d_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.
> Msg 8992, Level 16, State 1, Line 1
> Check Catalog Msg 3853, State 1: Attribute
> (referenced_major_id=1316251794,referenced_minor_i d=66) of row
> (class=0,object_id=173295727,column_id=0,reference d_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.
> Msg 8992, Level 16, State 1, Line 1
> Check Catalog Msg 3853, State 1: Attribute
> (referenced_major_id=1588252763,referenced_minor_i d=2) of row
> (class=0,object_id=173295727,column_id=0,reference d_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
> 'production'.
>
>
>
> Any ideas how fix that?
> thanks
>
>
|||well when i run DBCC CHECKDB on SQL 2000 i get no errors.
"Johnny" <Johnny@.discussions.microsoft.com> wrote in message
news:DB29A017-7F1E-4531-B31C-C3DD8B487C79@.microsoft.com...[vbcol=seagreen]
> Data corruption already existed prior to the backup taken. You have to
> find
> the good backup without data corrupted or try to run Checkdb with repair
> option.
> However, what I can see from the error messages repair may not repair all
> the errors. The other way could try to dump all objects to another new
> database.
>
> "Viktor" wrote: