Jagadeesh Chowdary (4/19/2014)
If the Database is in Suspect mode then follow the below steps to recover ur DB>Stop the SQL Service
>>Copy the MDF and LDF file and place in other safe location
>>>Then Start SQL service
>>>>Now also the Database will be in suspect mode only
>>>>>Drop are Detach the Database
>>>>>>Then Replace the MDF and LDF Files where it was Previously
>>>>>>>And Attach DB by Selecting the MDF File....
First, bad advice if you haven't determined why the database is suspect in the first place.
Second, it may simply be better to restore from a known good backup (full + t-logs).
Third, this is a 6 year old thread.