Finding a database in Suspect Mode. There can be many reasons for a SQL Server database to go in a suspect mode

Possible Causes

• The database could have become corrupted.
• There is not enough space available for the SQL Server to recover the database during startup.
• The database cannot be opened due to inaccessible files or insufficient memory or disk space.
• The database files are being held by the operating system, third party backup software, etc.
• There was an unexpected SQL Server Shutdown, power failure, or a hardware failure.

1. Open Microsoft SQL Server Management Studio
2. Connect to your database
3. Open new New Query
4. Add the following script and change [YourDatabase] after that start Execute

EXEC sp_resetstatus [YourDatabase];
ALTER DATABASE [YourDatabase] SET EMERGENCY
DBCC checkdb([YourDatabase])
ALTER DATABASE [YourDatabase] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ([YourDatabase], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [YourDatabase] SET MULTI_USER

Depends on database size how long will execute.
After that go and click the refresh button on Microsoft SQL Server Management Studio.
Your database should no longer be tagged as (suspect) and you should be able to access it.