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 New Query button:
      
      
   4. In the window that opens, enter the following commands one by one:
      EXEC sp_resetstatus 'PSIM'
      ALTER DATABASE PSIM 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('PSIM')
      ALTER DATABASE PSIM SET SINGLE_USER_WITH_ROLLBACK IMMEDIATE
      DBCC CheckDB('PSIM', REPAIR_ALLOW_DATA_LOSS)
      ALTER DATABASE PSIM SET MULTI_USER
      

   8. After you enter the commands, click the  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 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 Axxon PSIM database will be restored.