When attaching a database that was detached from another SQL Server instance(copied raw .mdf and ldf files)..
I got the error message below:
Error 602: Could not find row in sysindexes for database ID 25, object ID 1,
index ID 1. Run DBCC CHECKTABLE on sysindexes.
how can i solve this problem. i am using SQL Server 2000
Thanks and Regards
hi,
Could you be more specific. How did you detached the your database? Did you do it by backup and restore or copy the .mdf and .ldf file and attached.
Michael Castillones
|||hai oblax77
I copied raw .mdf and ldf files.
Regards
|||
hi,
Maybe your database was corrupted because the errors includes the system indexes already.
No comments:
Post a Comment