How to open sql server database file(.mdf) using sql server 2000 ?

[santhanalakshmi]

Hi,

I am trying to open database file(.mdf) using enterprise manager.

Right Click on Databases -> All Tasks -> Attach database


I am browsing the .mdf file from my local drive and finally clicking OK

It shows me an error. Please help me out.Thanks in advance. I cant able to find out

Microsoft SQL-DMO(ODBC SQLState:HY000)
Error 602: Could not find row in sysindexes for Database ID 10, Object ID 1, Index ID 1. Run DBCC CHECK TABLE on sysindexes

[NeoPa]

It looks as if the file may be corrupt.

Have you tried running "DBCC CHECK TABLE on sysindexes"?

[santhanalakshmi]

Hi,

No....how to run this "DBCC CHECK TABLE on sysindexes"? Tell me

[NeoPa]

It's hard for me to check the details for you as I'm woring on a 2005 server with access to 2008 Help ([SysIndexes] is 2000 specific and is not supported in later versions you understand), but your own access to Help should give you more helpful information.

My best guess, from what I can see, is that it would need to be something similar to :

USE Master
GO
 
DBCC CHECKTABLE ("sysindexes")
GO

[santhanalakshmi]

Hi,

I try this command. Its running finely in MS Server 2000 and also in MS Server 2008.Then,Why i can't able to attach my database in SQL Server.

[NeoPa]

I'm afraid I've exhausted my help here. I wish I knew more, but my SQL Server knowledge is quite thin really.

After you ran the DBCC, what did you see? Another error message? The same one?

[santhanalakshmi]

Hi,

This was my output after running this command

    USE Master
    GO
    DBCC CHECKTABLE ("sysindexes")
    GO

DBCC results for 'sysindexes'.
There are 105 rows in 4 pages for object 'sysindexes'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

[NeoPa]

That's good info, but I was more after what you get when you attempt to attach the database again.

[Jerry Winston]

Hello, did you ever succeed with attaching the database? If not, I have a few questions to ask so I can give you the proper answer.

What version originally attached to?
What version are you going to?
Have you attached/re-attached the database in the past?
What version of SSMS are you using?


FYI, you can always backup and restore a database to a new server without running the risk of changing/corrupting the database by detaching/copying/ftping/flash drive/network/cd/dvd/attaching the original data files to another server.

[santhanalakshmi]

Hi,
What version originally attached to? SQL SERVER 2000
What version are you going to? SQL SERVER 2000
Have you attached/re-attached the database in the past? No...This is the first time...i am trying out
What version of SSMS are you using? SSMS means SQL SERVER Management Studio.I am using Enterprise Manager.

Thanks for your response.