SQL SERVER 2000 DATABASE SUSPECT

Question

Dear Friends I have a Problem in SQL SERVER 2000 My database name Sleek_Kitchen got Suspect i came to know from Enterprise manager.I want to recover the data & make it Unsuspect. i dont have the backUp of Database. Please let me know how can solve this. Thanks & Regards Aamir

Aamir Khan · Answer

Hi Kunal the database was working Fine few days back i got a call from Client side tht there Software is not working  on Taking the Database mdf and ldf files on my side i came to know that it has been Suspect....Database is in Sql Server 2000

Kunal Vaishya · Answer

In Setting make sure file is actual same location at in mention in database setting if not then set it one more thing it was working properly before or not ? and what happens so database suspected can you tell me the reason

Aamir Khan · Answer

Hi Kunal both file's exists

Kunal Vaishya · Answer

Dear Check file mdf and ldf file exist or not