Database archiving - backup

Advanced features for access control

Database archiving - backup

Postby Jantar » Tue Jul 23, 2013 10:51 am

Advanced archiving is possible in program version V7.995.6.1030 or later.
When you install the software version V7.995.6.1030 (or later) you have the following options in the file JantarServiceV7.ini:
ArchivingPeriod=Daily
ArchivingTime=01:00
ArchiveDeleteEventsOlderThanDays=0
ArchiveBackupOnly=1
FirebirdDir=C:\Program Files\Firebird\Firebird_2_5\

"ArchivingPeriod=Daily" Define how often archive will be created. It may be created 'Daily', 'Weekly', 'Monthly' or 'Never'. The default is 'Never'
Daily - Archiving is done every day at selected time
Weekly - Archiving is done on Monday at the selected time
Monthly -Archiving is done first day in the month at selected time

"ArchivingTime=01:00" Archiving period is set at '01:00'. Archiving at exactly midnight is not advisable because of the procedure which is performed to recalculate the data for the day / month.

"ArchiveDeleteEventsOlderThanDays=0" Deletes events older than the number of days, specified by this parameter. Setting to less than 90 is not possible, so you can't accidentally erase too much data. By default is set to off, because "ArchiveBackupOnly" is set to "1".

"ArchiveBackupOnly=1" 1 = Does only backup. 0 = Does backup + activates "ArchiveDeleteEventsOlderThanDay". This feature, in combination with the "ArchiveDeleteEventsOlderThanDay", can be run only one time, if you would like to remove old data from the database.

"FirebirdDir=C:\Program Files\ Firebird\Firebird_2_5\" The JantarV7 has its own algorithm to distinguish between 64bit or 32bit OS. If you have installed Firebird to a different directory than C:\Program Files\ Firebird\Firebird_2_5\ or C:\Program Files (x86)\Firebird\Firebird_2_5\, or you are using different version of Firebird, then you need to correct this line.

Other possible settings that can be activated by adding the following lines:
"ArchFileName=Backup..." Change the name of the backup. You can add {DATE} to the new name. This will add the current date and time to the name. In this way each backup creates new file. NOTE that this can lead to a full disk, if the user does not delete the old copies. If this line is not added, the default backup name is "JantarV7Archive.gbk". In this way backup is always made in the same file and copied over the old one.

"ArchivingPath=C:\..." Change the folder where the backup of the database is created. If this line is not added, subfolder \Archive is created in the folder JantarV7Data.


Examples of performance archiving:
The backup is done every day at 00:30. Each backup is stored in its own file:

ArchivingPeriod=Daily
ArchivingTime=0:30
ArchiveDeleteEventsOlderThanDays=0
ArchiveBackupOnly=1
ArchFileName=JantarV7Copy_{DATE}.GBK

The backup is done every day at 00:30. Data older than two years is deleted every day. Since ArchFileName is not defined, the backup is always done in the same file:
ArchivingPeriod=Daily
ArchivingTime=0:30
ArchiveDeleteEventsOlderThanDays=730
ArchiveBackupOnly=0
Jantar
Site Admin
 
Posts: 158
Joined: Fri Aug 27, 2010 7:26 am

Return to Advanced features

Who is online

Users browsing this forum: No registered users and 1 guest

cron