If you have a database marked suspect, and do not have a backup to restore from, you can attempt to repair the database. This may lead to data loss and is most certainly not the best option (see: database backup).
Make sure there are no open connections to the database – stop all services that might attempt a connection. Run sp_who2 to check on open connections.
Run the commands one at a time and fix any errors as they appear:
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;
Restoring from a backup is the better way to fix this issue.
