SQL database goes in to suspect mode

Hello John,

Thanks for the quick response...

I tried to connect SQL database server & I found that SQL database goes in to suspect mode.

I read on many post that when I run following query, it get fixed:

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

Ref: http://www.data-base-recovery.blogspot.in/2012/03/how-to-repair-sql-server-2008-r2.html
http://www.vnypatel.com/repair-sql-server-2008-r2-suspected-database

But the repair output was following error message:

Warning: You must recover this database prior to access.
Msg 8921, Level 16, State 1, Line 5
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.
Warning: The log for database 'ServeDB' has been rebuilt. Transactional consistency has been lost. The RESTORE chain was broken, and the server no longer
has context on the previous log files, so you will need to know what they were. You should run DBCC CHECKDB to validate physical consistency. The database has
been put in dbo-only mode. When you are ready to make the database available for use, you will need to reset database options and delete any extra log files.
Msg 8921, Level 16, State 1, Line 9
Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.

How can I repair database? I want to know all possible reasons why sql server database going in to suspect mode.

Thanks John for your response...

Do you have any idea about third party sql database recovery software?
Actually i read in many articles or fourms about it that the software repair suspected database. I have already follow all the steps to repair suspected database except sql database recovery software. I read above blog post, he recommended stellar phoenix sql recovery software. But I don't know how to use it? He also write in many post that it shows the preview of suspected database. Can you plz suggest me the proper steps?

Hello John,

Plz suggest the answer or anyone who knows about it...