Recovering a SQL Server Database from Suspect Mode

Execute this statements line by line for clear result....

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