Can anybody help me out.
What are the causes behind the database becomes suspected and what are the different ways to recover that database?
I tried with sp_resetstatus. It saying that the database is not suspected (i.e suspect bit is 0).
What i have copied is taken the datafiles and logfiles and attached with a new name then it was working.