If built-in DBCC CHECKDB/repair tools fail to repair and restore the corrupt or damaged SQL server databases, it is good to opt for a third party application like this: http://www.serversdatarecovery.com/sqldatabase.html

This...

We successfully resolved the similar problem in our SQL server 2008 with the help of this tool: http://www.serversdatarecovery.com/sqldatabase.html

Hope it will also work for you !

You can try Stellar Phoenix SQL recovery software. It repairs corrupt SQL data files and objects. To see the preview of corrupt database, download free demo version from Stellar's official...

Hello Alina,

Have you fixed the problem?

You may loss some record of the tables after excuting DBCC CHECKDB with Repair_Allow_Data_Loss as Gila suggested.

Have a look on any third party recovery tool to avoid record or...

Hello Alina,

The best solution to troubleshoot consistency errors reported by DBCC CHECKDB is to restore from known good backup. However, if you are not able to restore from the backup...

As GilaMonster suggested firstly you should have to know what is the exact cause or reason for the suspect mode. You can know the reason of suspect mode by this...