prettsons (8/21/2012)
As HowardW & GilaMonster already mentioned the causes of database suspect mode. Please check this article, it has full solution of the issue: http://data-base-recovery.blogspot.com/2012/03/how-to-repair-sql-server-2008-r2.html
Not to be nasty, but that article is bad advice. Emergency mode repair is the last resort for fixing suspect databases, not the first step.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability