Introduction

This page covers the functions directly related to managing the database. These are part of the System Settings. The database contains all the system configuration including real time site data such as targets and alarms.

The functions covered on this page should be used with care, both restoring a database and resetting the database are destructive in that they will remove all current data from the system.

Contents

Backup Database

To backup a database:

1. Selecting the schedule backup option opens up the System Event Scheduler: Schedules | System Event Scheduler, in which a Backup Task can be created and scheduled, or a pre-existing Backup Task can be edited.
   
   

   Open

   

    

2. This will open an explanation of the Scheduler's details and options, including backup tasks, which is available on the Schedules page. However, it is important to note that there are two different types of Backup Task:

   1. A System Configuration Backup. This will backup the database records and the False Alarm Tracks.

   2. A System Configuration and Alarm Backup. This backup will include the database records, the False Alarm Tracks and the Alarm data.
      
      

   Open

   

    

3. In order to include alarms in the backup, Edit the backup task to enable the Backup Alarms checkbox.
   
   

    

4. Click the Run Now button:
   
   

    

5. A Database Backup Process notification will be displayed:
   
   

    

6. There will be three backup folders created - one for Alarms, Entities and False Alarm Tracks:
   
   

    

Videos

Here is a short video showing how to perform an immediate system backup:

Here is a video showing how to change a weekly system backup to a daily one:

Restore Database

To restore a database, you will have to restore the Entities, the False Alarm Tracks and the Alarms (if the latter have been selected to be backed up), each in turn.

1. Select the restore database option:
   
   

    

2. This opens the Restore Database dialog:
   
   

    

3. Select the Restore File dropdown in order to select a backed-up Entities file:
   
   

    

4. The details of the backed-up file will appear in the dialog:
   
   

    

5. Click Restore Database.

6. The system will close, and you will need to wait for the restored system to start.

7. Log in and repeat this process or the False Alarm Tracks.

8. Log in again and if you have selected to backup the Alarm data repeat the process for Alarms.

Restore Database Settings

Site Name: The location name of the system from which this file was saved.

Customer Name: To whom the system, from which this file was saved, belongs.

Backup Server: The server on which this file was backed up.

System Version: The version of the system software from which this file was backed up.

Version: The data version of this backup.

Can Restore: Whether a restore is possible, given any disparity between the databases. 

Number of Records: This indicates how many records will be restored.

Expire At Offset (days): This is only available when restoring a backup that contains alarm data. This provides an additional offset, in days, for how long you wish to keep the imported alarms from the time of restoration.

Reset The System

To reset the system to its default settings:

1. Select the Reset option.
   
   

    

2. A confirmation window will pop up:
   
   

    

3. You must type in the code displayed in the dialog to confirm you want to reset the software. Once ready, the OK button will be activated, and you can continue.

Additional Database Configuration Settings

File Chunk Size: The maximum number of Megabytes per message. Use small values if files cannot be read from the database.

Data Query Timeout: The timeout used when querying data for playback.

You can amend these settings by:

1. Click the Edit button:
   
   

    

2. Amend the settings as required and click Save.
   
   

Related Information