SQL server can become marked suspect for many different reasons.
File corruptions, hardware issues, OS issues, translog errors and on and on ...
Find the cause and then get your database back.....
Find the suspect database:
SELECT * FROM master.sys.databases WHERE state_desc='SUSPECT'
Now Fix the database:
---configure database set option: ONLINE:OFFLINE:EMERGENCY.
---Emergency: allows access to the database for data moving.(Read Only Mode)
ALTER DATABASE sandbox SET EMERGENCY
--- EMERGENCY MODE ALLOWS FOR DBCC CHECKDB, Allow data loss option requires single user mode.
ALTER DATABASE sandbox SET SINGLE_USER
if this statement succeeds the database is brought back online.
you'll need to set it to multi-user mode.
if it fails, there's no way to recover. You'll need to restore from backup.
NO_INFOMSGS : Suppresses all informational messages (Severity 10) and the report of space used.*/
DBCC CHECKDB (sandbox, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;
--- use my db.
--- Checks the allocation and structural integrity of all the objects in the specified database.
DBCC CHECKDB WITH NO_INFOMSGS;