Page History

...

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 Create request New Query button:
      Image Added
   4. In the window that opens, enter the following commands one by one:
      EXEC sp_resetstatus 'intellect'
      ALTER DATABASE intellect SET EMERGENCY
      
   5. After you enter the commands, click the Image Added button.
   6. Click the Create request button 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 Image Added button.
      The recovery process will start.

      Info
      title Note
      To check the recovery status, you need to create a request. You can do it by clicking the Create request button 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 Image Added 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 Image Added button (F5).

      
      

As a result, the Intellect database will be restored.