Page History

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

Image Modified

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.
      Image Modified
   3. Click the New Query button:
      Image Modified
      
   4. In the window that opens, enter the following commands one by one:
      EXEC sp_resetstatus '

...

1. 1. PSIM'
      ALTER DATABASE

...

1. 1. PSIM SET EMERGENCY
      Image Modified
      
   2. After you enter the commands, click the

...

1. 1. Image Modified button.
   2. Click the New Query button.
   3. In the window that opens, enter the following commands:
      DBCC CHECKDB('

...

1. 1. PSIM')
      ALTER DATABASE

...

1. 1. PSIM SET SINGLE_USER_WITH_ROLLBACK IMMEDIATE
      DBCC CheckDB('

...

1. 1. PSIM', REPAIR_ALLOW_DATA_LOSS)
      ALTER DATABASE

...

1. 1. PSIM SET MULTI_USER
      Image Modified

   2. After you enter the commands, click the Image Modified 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%' Image Modified After you enter the commands, click the Image Modified button. 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 Modifiedbutton.

      
      

As a result, the Axxon PSIM database will be restored.