You can try to recover your database from the "SUSPECT" state:

1. Set the Database to Emergency Mode:

   ALTER DATABASE [MYDB] SET EMERGENCY;

2. Set the Database to Single User Mode:

   ALTER DATABASE [MYDB] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

3. Run DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSS:

   DBCC CHECKDB ([MYDB], REPAIR_ALLOW_DATA_LOSS);

4. Set the Database to Multi-User Mode:

   ALTER DATABASE [MYDB] SET MULTI_USER;