Issue:
You have a myQA database in MS SQL that is tagged as (Suspect) and you are unable to run myQA software due to this connection issue.
Answer
If a database gets corrupted of if their is not enough space available in it it, it is possible that your Database may get tagged as (Suspect) in MS SQL. Please follow the below steps to repair it.
Step 1
Open Microsoft SQL Server Management Studio and connect to your database.
Step 2
Click the New Query button.
Step 3
Paste the following SQL script into your New Query page replacing [YourDatabase] with the name of your database.
EXEC sp_resetstatus [YourDatabase];
ALTER DATABASE [YourDatabase] SET EMERGENCY
DBCC checkdb([YourDatabase])
ALTER DATABASE [YourDatabase] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB ([YourDatabase], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [YourDatabase] SET MULTI_USER
Step 4
Click Execute.
Here is an example how will it look like.
