Hi,
Just try if you have a database which is in suspect mode. If you can’t save it unfortunately you will lose your database.
EXEC SP_RESETSTATUS ‘db_name’;
ALTER DATABASE db_name SET EMERGENC
DBCC CHECKDB(‘db_name’)
ALTER DATABASE db_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CHECKDB (‘db_name’, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE db_name SET MULTI_USER
Regards..
