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....
That's not going to fix a damn thing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability