The ‘Suspect’ mode of the SQL database indicates that the recovery process has started but failed to complete. The database goes into suspect mode if the primary data file is damaged or the database ...

However, the easiest option to repair the database with a new log is by using Stellar Repair for MS SQL. This software can rebuild a corrupted database with complete precision and integrity.

Joey on SQL Server How To Automate Tasks in Azure SQL Database Knowing how to automate tasks in the cloud will make you a more productive DBA.