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.
No comments:
Post a Comment