Recovering SQL Server Database From Suspect Mode

Follow below steps to recover database from suspect mode:

1. ALTER DATABASE [database_name] SET EMERGENCY 
2. DBCC checkdb('database_name') 
3. ALTER DATABASE [database_name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE 
4. DBCC CheckDB ('database_name', REPAIR_ALLOW_DATA_LOSS)
5. ALTER DATABASE [database_name]  SET MULTI_USER

If it does not work for you, then go for thrid party tool or restore database from available backups.