User's Guide

25 Database Backup 83
7signal Ltd, Panuntie 6, FI-00620 HELSINKI, FINLAND, [phone], [e-mail], www.7signal.com
7signal Sapphire Carat Carat User Guide Release 3.0
to be accessible easily from the hosting server but it is encouraged to use separate physical file
systems for these two.
NOTE: log files and databases residing in the same physical disk mean duplicate
disk operation efforts on the same device. It is good design to separate logs and
actual databases to different physical storage devices.
25.3.7 Changing backup settings
Install time gives the option to set all the backup related settings.
To change the settings while the system is installed and in production later, please use the tool
7db and the backup sub-command. Complete guide to 7db tool is in the appendix of
Deployment Guide.
Below there are example commands to give the reader an overview:
# 7db backup remove
# 7db backup set weekly Wed 00:30 /mnt/backups /mnt/backups
# 7db backup set daily 03:00 /mnt/backups
# 7db backup set directory /mnt/newbackups
# 7db backup set weekly Sun 01:30
# 7db backup set type online
# 7db backup now /mnt/backups online
25.4 Restoring backups
Backups are located in the user-defined directory. Backup files contain timestamp in the name,
also the operating system timestamp exists.
NOTE: the user must be aware which backup file should be used. Therefore it is
essential to understand the backup system and the related files.
Based on this information one must choose which backup to restore.
Restore command is
# 7db backup restore <absolute-file-path>
NOTE: while issuing restore command when using online backup, it might be
necessary for the system to retrieve files from the infinite archive directory when
the restore command is issued. The access time is affected by the physical device.
If the system cannot access the files, restore shall not happen. The most recent
offline backup is the alternative point of recovery.