The Intellect database can go into Suspect mode because of a sudden server reboot or file system damage.

To restore the database from this mode, do the following:

  1. Check system disk for errors:
    1. run command line as administrator;
    2. enter the command <chkdsk c:> to search for errors;
    3. if there are errors, use the </f> parameter to fix them;
    4. perform step b again to recheck the system disk.
  2. If no errors were found at step 1, start the recovery:
    1. Launch Microsoft SQL Server Management Studio Express (SSMSE).
    2. Connect to the required MS SQL instance.
    3. Click the New Query button:
    4. In the window that opens, enter the following commands:
      EXEC sp_resetstatus 'intellect'
      ALTER DATABASE intellect SET EMERGENCY
    5. After you enter the commands, click the button.
    6. Click the New Query button.
    7. In the window that opens, enter the following commands:
      DBCC CHECKDB('intellect')
      ALTER DATABASE intellect SET SINGLE_USER_WITH_ROLLBACK IMMEDIATE
      DBCC CheckDB('intellect', REPAIR_ALLOW_DATA_LOSS)
      ALTER DATABASE intellect SET MULTI_USER

    8. After you enter the commands, click the button.
      The recovery process will start.

      To check the recovery status, you need to create a request. You can do it by clicking the New Query button in a new window and entering the following command:

      SELECT
      [command]
      ,[start_time]
      ,[percent_complete]
      ,[estimated_completion_time]/60000. AS [estimated_completion_time_min]
      FROM sys.dm_exec_requests
      WHERE [command] LIKE '%DBCC%'

      After you enter the commands, click the button (or pressing F5 on the keyboard). After that, a line containing the percentage of completion and the remaining time will appear in the window below. To refresh the line, click the button (F5).


As a result, the Intellect database will be restored.