2K-to-2K Attach Error: Could not find row in sysindexes for database ID...

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.

2005: Database cannot be opened

Hello,
Could you explain me please the following error:

"Database 'DemoDotNET' cannot be opened due to inaccessible files or
insufficient memory or disk space. (Microsoft SQL Server, Error: 945)"

I have checked: free disk space is large enough, I have much enough
memory, other files in the directory are accessible.

Here is tail of ERRORLOG:

2006-06-12 21:19:55.68 Logon Error: 18456, Severity: 14, State:
16.
2006-06-12 21:19:55.68 Logon Login failed for user 'PC\Robert'.
[CLIENT: <local machine>]
2006-06-12 21:20:43.39 Server Server resumed execution after
being idle 1 seconds: user activity awakened the server. This is an
informational message only. No user action is required.

Please help to solve this.
Thank you.
/RAM/R.A.M. (r_ahimsa_m@.poczta.onet.pl) writes:
> "Database 'DemoDotNET' cannot be opened due to inaccessible files or
> insufficient memory or disk space. (Microsoft SQL Server, Error: 945)"
> I have checked: free disk space is large enough, I have much enough
> memory, other files in the directory are accessible.

Or there is some file for DemoDotNET which is located somewhere where
you don't think it is.

Unfortunately, with the information at hand it's impossible to say. You
could at least have posted the part of the error log where this message
appears. Or tell us when you get this error. Does it happen at startup?
Do you try to attach the database? Something else?

And, not the least, you did not tell us which version of SQL Server
you are using.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Mon, 12 Jun 2006 21:36:15 +0000 (UTC), Erland Sommarskog
<esquel@.sommarskog.se> wrote:

>R.A.M. (r_ahimsa_m@.poczta.onet.pl) writes:
>> "Database 'DemoDotNET' cannot be opened due to inaccessible files or
>> insufficient memory or disk space. (Microsoft SQL Server, Error: 945)"
>>
>> I have checked: free disk space is large enough, I have much enough
>> memory, other files in the directory are accessible.
>Or there is some file for DemoDotNET which is located somewhere where
>you don't think it is.
>Unfortunately, with the information at hand it's impossible to say. You
>could at least have posted the part of the error log where this message
>appears. Or tell us when you get this error. Does it happen at startup?
>Do you try to attach the database? Something else?
>And, not the least, you did not tell us which version of SQL Server
>you are using.

I am using SQL Server 2005.
In directory of the database I have files: DemoDotNET.mdf,
DemoDotNET_log.ldf.
I got the error when I try to see properties of database, or script
database or open in C#.NET or VB program.|||R.A.M. (r_ahimsa_m@.poczta.onet.pl) writes:
> I am using SQL Server 2005.
> In directory of the database I have files: DemoDotNET.mdf,
> DemoDotNET_log.ldf.
> I got the error when I try to see properties of database, or script
> database or open in C#.NET or VB program.

If you do

SELECT name, physical_name
FROM sys.master_files
where database_id = db_id('DemoDotNet')

does physical_name agree with the files you see in Explorer?

If they do, my suspicion is that the log file has been tampered with,
and is not usable.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx