How to fix a suspected database in MSSQL

1. Open Microsoft SQL Server Management Studio
2. Connect to the database server instance
3. Click New Query
4. Type the following commands:
EXEC sp_resetstatus {DatabaseName};
ALTER DATABASE {DatabaseName} SET EMERGENCY
DBCC checkdb({DatabaseName})
ALTER DATABASE {DatabaseName} SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ({DatabaseName}, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE {DatabaseName} SET MULTI_USER
5. Click Execute
6. Refresh the list of databases

{DatabaseName} is the name of the database that you want to fix

Example:

I want to fix the luizcgjr database that is maked as suspect:

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

Source: https://support.managed.com/kb/a398/how-to-repair-a-suspect-database-in-mssql.aspx