How To Recover Pasdb Suspect
1.ALTER DATABASE posdb SET EMERGENCY 2.DBCC checkdb(posdb) 3.ALTER DATABASE posdb SET SINGLE_USER WITH ROLLBACK IMMEDIATE 4.DBCC CheckDB (posdb, REPAIR_ALLOW_DATA_LOSS) 5.ALTER DATABASE posdb SET MULTI_USER This is the command for all data base recover from suspect . First rename db with suspect db name and then Execute query one by one , then it is solved with out any data lose.