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

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: https://download.f-secure.com/support/tools/pm/recovery-tool/fspm-recovery-tool-12.10.42001-cf555fd0.zip
Documentation: https://download.f-secure.com/support/tools/pm/recovery-tool/README

Command name

fspms-db-recover

Usage

Depending on which recovery information you want to use:

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>
```

Recovery DB with all data from specific corrupt DB directory

fspms-db-recover.bat -curDir=<corrupt-db-dir> <recovered-db-dir>

Recovery DB without Scanning Reports

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

Recovery DB without Alerts

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

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>

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>
```

Output

At the output, the <recovered-db-dir> contains:

Valid H2 database files;
Management keypair admin.pub/admin.prv with the password 'password'.

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

Example:

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 -curDir 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.