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.
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