The Recommended way to recover the database is by restoring from a backup made prior to the corruption, rather than repaired. I found a similar question [here ] : http://ask.sqlservercentral.com/questions/375/how-to-fix-a-database-marked-as-suspect
-- Take the database into Emergency mode ALTER DATABASE [Database Name] SET EMERGENCY GO -- Change into single user mode ALTER DATABASE [Database Name] SET SINGLE_USER -- Then run DBCC CheckDB command. Warning! REPAIR_ALLOW_DATA_LOSS can cause some data to be lost!. DBCC CheckDB (<[Database Name]> , REPAIR_ALLOW_DATA_LOSS) -- Change from multiuser ALTER DATABASE dbName SET MULTI_USER
No one has followed this question yet.