Based on experience and practice, there is a proven way to recover MS #SQL from Suspect Mode:
Step 1: Switch the database to the Emergency Mode.
Step 2: Perform the function Consistency Check on the Master Database.
Step 3: Bring the database into Single User Mode, and then roll back the previous transactions.
https://ibmimedia.com/blog/219/recovering-a-database-from-suspect-mode-in-sql
sql database emergency mode to normal mode
how to recover suspect database in sql server 2000
why database goes to suspect mode in #sql server
database in suspect mode in always on
sql server database suspended mode
how to make #database suspect in sql server
how to repair suspect database in sql server 2008 r2
sccm database suspect
