In the window "Database backup settings" you can configure frequency and type of a copy to be created.
 |
| Fig. Setting a database copy. |
Database
Pole zawiera następujące opcje:
|
|
Activating or deactivating the option of automatic creating of a database copy.
IT IS NOT recommended to deactivate the function of creating a database copy.
Even in the case when the administrator creates a backup copy for the entire disk on which the database is located, IT IS NOT recommended to deactivate the function.
It must be remembered that when the option of creating a database backup copy is deactivated, the database will "swell" (increase its size with history of the performed operations).
|
|
|
|
This is the same folder of "database copy" that we define when starting the program for the first time.
|
|
Opens the window "Database backup settings":
 | | Fig. Window of "Database backup settings" |
In this window you need to set:
| ➢ | type of the database copy being created: |
| - | Full – the entire image of the database is created. |
| - | Differential – this is a copy of all data which have been changed (also new ones) from the time of creating the last full backup copy. |
| - | Logs – this is a copy of operations that have been performed on the database. |
| ➢ | Frequency of creating a database copy. It is possible to select from three different frequency schemata: |
| - | daily – set every how many days a copy is to be created, |
| - | weekly – select on which day of the week a coy is to be created, |
| - | monthly – there are two possibilities to created a monthly copy: |
| ~ | every (1 to 31) day of a month every (1 to 3) months, |
| ~ | every (1 to 4 or the last) (Monday to Sunday) month every (1 to 3) months. |
| ➢ | depending on frequency settings, it needs to be defined whether a copy is to be created: |
| - | once at (00:00 to 23:59), |
| - | every (1 to 59 or 1 to 23) (minutes or hours) Start (00:00 to 23:59) Finish (00:00 to 23:59) |
In order for the values to appear in the first column one needs to select values in the second columns beforehand (minutes or hours).
|
|
Defined frequency: Weeks -> Thursday below Create every 35 -> minutes -> Start at 07:00 -> Finish at 10:00. which means a copy will be created every 35 minutes, between 07:00 and 10:00 every Thursday.
|
|
|
|
Activating or deactivating the option of automatic deletion of older backup copies after a number of days (from 1 to 59).
|
|
|
|
Status of making database backup
|
|
Displays a window, in which history of creating the database backup copies is shown. This window can be triggered if you double-click a given line of a sentence.
|
|
Refreshes the status of creating a database copy.
|
|
Open an available log file list.
|
|
The list shows tasks (creating database copies), their activity, status, etc.
Tasks designation: D – full copy, F – differential copy, L - logs.
If the status of a given task is empty it means that creating this type of a backup copy has not been activated or the program has not yet attempted to create such copy, e.g. creating the copy is set for Thursday and the check-up date is Wednesday.
When you double-click the task line a window of history of creating a database copy process will appear and detailed information concerning the error will be displayed.
The most frequent reasons for error occurrence during the process of creating a database copy:
- wrongly set path for the database copy,
- lack of serves privileges to save a database copy in the set directory,
- no space on the disk.
|
|
When the task status shows "failed" it means that the database copy has not been created.
It is recommended to localize the reason for such error of failing to create a database copy as soon as possible and repair it.
|
|
|
|
|
|
