HVS32 database archiving service
Features
HVS32 - fully automated, time-controlled database archiving. The HVS32 database archiving service offers the option of determining when and which dispatch data should be automatically archived in an archive database. The archiving interval can be configured using the scheduler. In addition, maintenance work and performance improvements are automatically carried out on the database before archiving so that a high-performance HVS32 database is always available. In addition, an e-mail is automatically generated for notification in the event of an error.
System requirements
- At least 4 x the size of the HVS32 database as free hard disk space*
- At least 2 GB RAM memory
- Windows user with full administrator rights (user should be able to stop and start services via cmd command net stop)
- Windows Server 2008 64-bit / Windows 10 64-bit or higher
- Firebird 2.5
* Alternatively, archiving can be moved to a separate partition. The storage requirements are then:
- 3x size of the HVS32 database on the swapped partition
- 1x size of the HVS32 database on the database partition for a further backup copy
(see Database configuration -> Working directory for the configuration of a swapped partition)
Installation
The HVS32 database archiving service can be configured via the DBServiceKonfigurator in the DBService installation directory.
Database configuration
All parameters for the connection to the HVS32 productive and archive database can be set in this dialog.
Server: The IP of the server on which the Firebird service is installed must be stored here.
Port: The port of the Firebird service must be stored here (for Firebird "3050" as default).
Datenbank: Complete path to the HVS32 productive database incl. file name.
Benutzer: Firebird database username
Password: Firebird database password
Archiv erstellen: This option determines whether an archive should be created or whether the data to be archived should be deleted.
This option can be useful if you want to automatically comply with GDPR deletion deadlines at a certain interval after consultation with the DPO.
Attention: The data to be deleted is then irrevocably lost!
Archiv-Pfad: Path to the HVS32 archive folder.
Archivname: File name of the archive
Arbeitsverzeichnis: (optional) The directory in which the archiving should work.
Attention: The path must not correspond to the HVS32 database directory.
Here you have the option to move a large part of the required hard disk space to another partition.
This option can therefore be useful if there is not enough space available on the HVS32 partition and it is not so easy to extend the partition (see system requirements).
Sweep Intervall: Number of transactions before a sweep is to be executed (default: 20,000).
Archiving configuration
In the archiving configuration, you have a sub-selection of configuration items to choose from:
Archivoptionen
In the archive options, you can define the time period for the data to be archived and make special settings for archiving.
In the standard interval, you define the time period for all intervals that are not specifically defined. An interval always describes how long data should remain stored in the productive database. In this example of 2 weeks, this means: everything older than 2 weeks is archived, everything younger than 2 weeks remains in the productive database.
Spezial-Intervalle
You can define different intervals for different types of consignments (open, closed for the day, canceled, ...) or even completely deactivate archiving for this type of consignment.
