<< Click here to display Table of Contents >> Navigation: Administration panel > [014] Settings > Administration panel:

Database backup settings

Contents

In the window "Database backup settings" you can configure frequency and type of a copy to be created.

Fig. Setting a database copy.

Database

Creating backup database

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).

Jobs schedule executed by:

The frame is only visible for a database connected to SQL Server™ version 2008R2 or later.

SQL Server Agent service

For SQL Server™ Express version - after selecting this option, the program displays a warning that database backup is not possible.

For other versions of SQL Server™, database backup copy will be created by the SQL Server™ Agent service. In the Status of making database backup box, the history of backups made directly from SQL Server™ Agent will be displayed.

INELO Service

Backup copy of the database is created by the INELO Service which comes with the program. Most importantly, the service works on any version of SQL Server (from 2008R2 up).

Database copy path

This is the same folder of "database copy" that we define when starting the program for the first time.

The [Settings] button

Opens the window "Database backup settings":

The settings work for the database backup service currently selected in the frame: Jobs schedule executed by: (see description above).

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.

Delete database backups after

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

View the record of making database backups

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.

Refresh status

Refreshes the status of creating a database copy.

View actual "SQL Server Log"

Open an available log file list.

Status of making database backup

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.