Possible reasons of the database going into suspect mode are:

1. Log files or data files
2. Due to lack of disk space, suspect mode like issue crops up in SQL Server database.
3. Due to improper shutdown of DB server
4. Inability of SQL Server to Roll-back operation or Roll-forward operation

Solution:

1. To recover the database from the suspect mode, we need to connect SQL Server Management studio using ‘sa’ login credentials
2. Run this following query one by one:

EXEC sp_resetstatus ‘COSEC';

ALTER DATABASE COSEC SET EMERGENCY

DBCC checkdb ('COSEC')

ALTER DATABASE COSEC SET SINGLE_USERWITH ROLLBACK IMMEDIATE

DBCC CheckDB ('COSEC', REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE COSEC SET MULTI_USER

Now DB is online: