SQL 2000 suspect database

[darronb]

Hi

I hope someone can help, I am not an expert with SQL so bare with me.

I am using MSDE 2000 on an XP PC.

I have been given a mdf file that I need to look at the data.

So far I have created a database using enterprise manager of the same name as the mdf file, I then Stopped SQL and copied the file into the data directory.

I have restarted SQL and the database says it is now suspect.

I can not seem to get any further. Your help would be appreciated. Thanks

 

[gmmastros]

If you have the mdf and the ldf, then all you need to do is to attach the database.

If you only have the mdf file, then you should use:
sp_attach_single_file_db

If this mdf file came from another computer that is using a newer version of SQL Server (SQL2005 or SQL2008), then you will not be able to attach the database to msde2000.



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom