Introduction

This article describes the device for backup and recovery of servers.

Backing up is very important. It is necessary to save data in case of breakdowns and other errors. In r_keeper 7, backups are configured separately for each server.

To save all the data necessary for recovery, it is recommended to set up a backup for:

Directory servers
Cash server.

Let's start with the directory server settings.

Directory Server

The directory server backups are by default stored in the folder: \ base \ backups \ databases

The databases folder stores backups named by the date and time of creation.

Each of the folders contains three files:

rk7.udb is the main database in which all directories are stored. From it, the data goes into SQL
check.udb - sales database. The data gets here after the closure of general shifts
rk7.bls - contains pictures of the floor plans, if any.

All 3 files must be saved.

Please note that r_keeper 7 does not archive backups and cannot upload them to an FTP server. To improve fault tolerance, we recommend doing this with third-party tools.

To set up a directory server backup:

Open the manager station
Go to Settings> Options> Installation> Directory Server> Backup

Configure the following parameters:
Start time of backup - in the General section, in the Link line, select the backup period from the drop-down list. The time at which the system is allowed to back up.
Periods are configured in the Order> Periods menu.

For more information on setting up periods, see the article Periods Reference

Maximum number of backups - in the Primary section, in the Number line, specify the maximum number of backups
Frequency of backups - in the Main section, in the Time line, specify a number. This setting means to back up every specified period of time.
Path for saving files - in the Main section, in the String line, specify the relative or absolute path to the folder where the copies of the databases will be saved

Save your changes.
Cash server

Each POS server has its own backup settings. This means that if you have 3 cash register servers, they can have 3 different backup settings.

Read more about the data storage structure in the article description of the system and data storage

If the backup path has not been changed, by default these backup files are stored in the \ midbase \ Backup folder

It contains files:

Work.udb - open shift file

sh.udb - the shift file before closing the general shift

ns.udb - file of a new shift, after closing and before payment of the first check, may contain unpaid orders from the previous shift.

To set up a POS server backup:

In the manager station and go to Tools> Stations and Devices

Choose your restaurant and allocate a checkout server. Go to the Properties tab.

In the Backup section, you will see the settings:

Number of copies
Backup path - relative or absolute
Number of shifts - the number of shifts to be backed up
Frequency - back up every specified interval in minutes
Number of checks - by default 100
Perform backup - check the box to activate.
R_keeper 7 recovery

To restore r_keeper 7 from a backup:

Install r_keeper 7 using the installer or through the archive
Without starting the servers, copy from the previous to the installed version of r_keeper 7:
Files rk7.udb, check.udb and rk7.bls to the directory server base directory
WORK.UDB file in the midbase folder of the cash server. If there is no such folder, then create it. If there is no WORK.UDB file in the \ midbase \ Backup folder, but there is a similar one, for example: work2.udb - copy the most recent file with this name and rename it WORK.UDB
The files common.ini, repsserv.ini, rk7man.ini, rk7srv.INI, RKEEPER.INI, ShelterConnect.ini, wincash.ini, winprint.ini in:
\ bin \ win - for r_keeper 7 installed using the archive
the corresponding folders for r_keeper 7 installed with the installer.

In the rk7srv.INI file in the [REFSERVER] section, change the setting USESQL = 0

[REFSERVER]
USESQL = 0

Start the directory server. It will automatically load your database
After the first start, re-license all the servers that had the license
If the database has been corrupted, then:

Reconfigure the connection to the new external database and export the files
In the rk7srv.INI file in the [REFSERVER] section, change the setting from USESQL = 1 to USESQL = 0
Start the cash register server.

Restore using r_keeper 7 backups completed. The system will continue to work with the previously saved databases.
To make sure that the system has been restored successfully, check:

The presence of all previously closed shifts - in the manager station go to the Service menu> Information about general shifts

Work of reports - build a cube report. More details 

do not read in the article the concept of cubes and the creation of reports based on them

If the check is successful, the system is restored, r_keeper 7 will continue to work with the previously saved databases.

Useful articles

It will be useful to read the articles:

Transferring r_keeper 7 to another computer
Restoring the shift after the close of the day.