If the DBCC CHECKDB command doesn't work or to avoid data loss, you can use a professional SQL database repair software, such as Stellar Repair for MS SQL. It is an MVP-recommended software to repair ...

A SQL Server may mark the database in SUSPECT mode after detecting a problem in the log file due to reasons like hardware malfunction, disk space issue, system crash, etc. A database in suspect mode ...