F-SECURE POLICY MANAGER 9.0 Administrator's Manual - Maintaining Web Reporting

Page of 102

Download

Bookmark us

Maintaining Web Reporting

This section covers the most common Web Reporting maintenance tasks.

Note: Web Reporting is turned on and off during the installation of Policy Manager Server. To turn Web

Reporting on or off, you need to reinstall Policy Manager Server. Restricting access to the local machine

is also set during installation.

For maintaining the database used by Web Reporting, a batch file is provided. This file is located under

\Management Server 5\Web Reporting\firebird\tools

and can be used whenever noticeable degradation of report generation speed occurs. On Windows Vista

and Server 2008, the batch file should be run with administrative privileges

Creating a backup copy of the Web Reporting database

Regular backups are recommended to prevent the loss of useful reporting data.

You can create a backup of the Web Reporting database on a backup media as follows:

1. Stop the Policy Manager Server service.

2. Copy the file

C:\Program Files\F-Secure\Management Server 5\Web

Reporting\firebird\data\fspmwr.fdb

to the backup media.

You can also use some compression utility to compress the file. Using a compression utility also provides

you a means to check that the backed up database is still intact.

3. Restart the Policy Manager Server service.

Note: A backup copy protects historical data against corruption. It can also be used to archive old

data that would be deleted when the maximum data storage time in the Web Reporting database is

modified.

Restoring the Web Reporting database from a backup copy

You can restore backed-up data that has been lost due to corruption or when the maximum data storage time

in the Web Reporting database has been modified.

You can restore the Web Reporting database from a backup copy as follows:

1. Stop the Policy Manager Server service.

2. Copy and decompress the

fspmwr.fdb

file from the backup media to the following directory:

C:\Program

Files\F-Secure\Management Server 5\Web Reporting\firebird\data

3. Restart the Policy Manager Server service.

78 | F-Secure Policy Manager | Web Reporting