SQL 2000 database suspect

[jmcgarvey]

Hi all,
A site that I am working in recently had a new server installed. All of the companys databases were backed up except 1, but we do have the mdf and ldf files for this db.

We have tried creating the db in the new SQL install then overwriting the mdf and ldf files with older files from the previous server but the DB keeps coming marked suspect.

Can anybody please help!!!!

Cheers!

 

[tlbroadbent]

Use sp_attach_db or use Attach Database in SQL Enterprise Manager. Details can be found in SQL BOL. If the databse still shows as suspect, check the error log for the reason. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.