Repair SQL Server Database marked as Suspect or Corrupted

EXEC sp_resetstatus 'real_set_2'

ALTER DATABASE real_set_2 SET EMERGENCY

DBCC CheckDB ('real_set_2')

ALTER DATABASE real_set_2 SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ('real_set_2', REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE real_set_2 SET MULTI_USER

(source: http://www.sqlservercurry.com/2011/03/repair-sql-server-database-marked-as.html)