Patriot Archive Database
The Patriot Archive Database is an optional database that can be installed alongside the main Patriot database to store historic data. By default new installations of Patriot do not have the Patriot archive database enabled because it is not necessary for the majority of Patriot users who can simply use database pruning while keeping database backups for historic data access. The most common scenarios where you may want to consider using a separate archive database are:
- Due to regulatory requirements or other reasons you must keep a very large amount of historic data readily accessable in your active Patriot database.
- You have restrictions on your database size (e.g. Express version of Microsoft SQL Server) which prevent you from keeping an adequate amount of historic data in your active Patriot database.
Initialising a new Archive Database
If you do not have a Patriot Archive Database installed you can create one with the Patriot Utilities program (Utilities.exe located in the Patriot V6 Client installation folder).
Maintenance > Database > Initialise Archive Database
Make sure to choose the correct language for the collation of the new database - it must match your main Patriot database. The auto-detect language button will attempt to detect the correct collation language for you.
Enable/Disable Archive Database
If you do not have an up-to-date Patriot archive database you must initialise one before enabling the archive database.
You can enable or disable the Patriot Archive Database on the Patriot server via the Patriot Configurator program (SettingsManager.exe). In the Data Service Settings section Check or Uncheck "Use Archive Database" to enable or disable the Patriot Archive Database. You must restart the Patriot Data Service for the changes to take effect.
After enabling or disabling the Patriot Archive Database you should always disable and then re-enable database pruning/archiving.
Accessing Archived Data
Most archived data is automatically loaded as required when viewing data within a client. The client signals, activations, and operator log will automatically load from the archive data base as needed. The operator will not be aware the data has been loaded from the archive database. Note the clients work orders will only display from the current database, and currently doesn't support loading from the archive database. To view a clients archived work orders you will need to use the work order report.
Reports which include any data that can be archived will contain an option to load from the archive database. This option should only be enabled if needed (it's likely the data required will be stored in the archive database) as it will have an impact on the performance of the report.
The following locations support automatic archive loading:
- Maintenance > Activations > Completed Activations
- Maintenance > Clients > Operator Log
The following locations do not support automatic archive loading:
- Maintenance > Clients > Work Orders
- Monitoring > Signals