Documentation for Axxon PSIM 2.0. Documentation for other versions of PSIM is available too.

Previous page Compressing the database size  Appendix 4. Updating Java time zones for proper operation with archive in iOS client Next page


The Axxon PSIM 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 '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.

      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.

  • No labels