• 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