When ever you find that the data base is in suspect mode use the below script.
Exec Sp_resetstatus ‘Yourdbname’
Alter database yourdbname set emergency
Dbcc checkdb(yourdbname)
Alter database yourdbname set single_user with rollback immediate
Dbcc checkdb (‘yourdbname ‘, repair _allow_data_loss)
ALTER DATABASE yourDBname SET MULTI_USER
Regards,
Adapala.N