Using the Policy Manager for Windows Database Recovery Tool (Version 10.00 and later)

This discussion has a more recent version.
Khairul_A Posts: 272 F-Secure Employee

This article describes the use of the database recovery tool available since PM version 12.10.

For version 12.00 and newer, the recovery tool is included in the installation with the following file path: Program Files (x86) \F-Secure\Management Server 5\bin

If you are running the Policy Manager version 12.00 or older, use the following recovery tool available on our download server:
  • Tool: <A href="" target="_blank" rel="noopener noreferrer"></A>
  • Documentation: <A href="" target="_blank" rel="noopener noreferrer"></A>

Command name



Depending on which recovery information you want to use:

  1. Recovery DB with all data from default DB directory of PM

    (%F_SECURE_DIR%\Management Server 5\data\h2db)

    fspms-db-recover.bat <recovered-db-dir>
  2. Recovery DB with all data from specific corrupt DB directory

    fspms-db-recover.bat -curDir=<corrupt-db-dir> <recovered-db-dir>
  3. Recovery DB without Scanning Reports

    fspms-db-recover.bat -noReports <recovered-db-dir>
  4. Recovery DB without Alerts

    fspms-db-recover.bat -noAlerts <recovered-db-dir>
  5. Recovery DB without Scanning Reports and Alerts from the custom database directory

    fspms-db-recover.bat -noReports -noAlerts -curDir=<corrupt-db-dir> <recovered-db-dir>
  6. Recovery DB without Scanning Reports and Alerts from default DB directory of PM

    (%F_SECURE_DIR%\Management Server 5\data\h2db)

    fspms-db-recover.bat -noReports -noAlerts <recovered-db-dir>


At the output, the

  • Valid H2 database files;
  • Management keypair with the password 'password'.

The result of recovery operation is written into the file named 'recovery.log' in the current directory.


  • fspms-db-recover.bat c:\temp\h2db-recovered
  • fspms-db-recover.bat -curDir=c:\temp\h2db c:\temp\h2db-recovered
  • fspms-db-recover.bat -noAlerts -curDir=c:\temp\h2db c:\temp\h2db-recovered 

Notes and issues

  • Always use the recovery tool provided with your installation of Policy Manager. If you are using Policy Manager version 12.00 or older, you can download the tool from our ftp server (see above). The recovery tool automatically identifies the version of Policy Manager. If it is unable to identify the Policy Manager version and recover the database, please contact F-Secure support.
  • When recovering the database from the default directory (no
    parameter is specified), Policy Manager Server must be stopped before running the tool.
  • In some cases, the database is broken so badly that it can't be opened at all. In this case, the 'recovery.log' file will contain an error message similar to the following:

    org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; 

    Unfortunately, this indicates that there's no way to recover this database.

  • In other cases, some of the vital tables cannot be recovered automatically. However, there's still a chance to rescue the data from those tables manually. In this case, please contact F-Secure support.

Contact information

Please submit any issues you might be facing to F-Secure support according to the support contact information available in your License Agreement.