OK, I have read through many similar posts about this issue and most of them are due to that, they wanted to attach 2K5 MDF to 2K. But unfortunately, I was trying to attach my old SQL2K MDF file (with LDF) to my SQL2K enterprise manager, as well as query analyzer, and I still hit this error:
Server: Msg 602, Level 21, State 50, Line 1
Could not find row in sysindexes for database ID 7, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Connection Broken
I have also tried starting sql server in single user mode and run the following:
dbcc checktable ('sysindexes', repair_rebuild)
and get this in QA:
DBCC results for 'sysindexes'.
There are 100 rows in 4 pages for object 'sysindexes'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
In command window, I get this:
2006-06-05 03:12:32.15 spid51 DBCC CHECKTABLE (master.dbo.sysindexes, repair_
rebuild) executed by sa found 0 errors and repaired 0 errors. Elapsed time: 0 h
ours 0 minutes 0 seconds.
After that I tried to attach the same file again, both with and without LOG/LDF file, still getting the same error as mentioned earlier. I'm getting nervous now because this MDF is too critical to me. Can somebody help? I don't mind sending my MDF file to anyone who can help me to recover it! Thanks!
Antonio
I think problem here is: You attached it in SQL2005 already so this file is changed. Try attached it again in 2005 version and do an import wizard from 2000 version.
Hope this help.
