Initialising a new Patriot Archive database with the Patriot Utilities
program
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 recommended for the majority of Patriot users. The most common scenario where you may want to consider using a separate archive database is where you only have access to a limited version of Microsoft SQL Server that imposes limits on the maximum size of your main Patriot 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.
Warning: 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.
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.
Maintenance -> Activations -> Completed Activations, supports automatic archive loading.
Maintenance -> Clients -> Work Orders, doesn't support archive loading.
Maintenance -> Clients -> Operator Log, supports automatic archive loading.
Monitoring -> Signals, doesn't support archive loading.