User's Manual

23 Database Backup 91
7signal Ltd, Panuntie 6, FI-00620 HELSINKI, FINLAND, [phone], [e-mail], www.7signal.com
7signal Sapphire Carat Carat User Guide Release 3.1
TIP: with frequent and detailed automated reports the loss of measurement data
becomes less drastic as the needed information may be found in the reports.
23.3.4 Changing log settings
Install time gives the option to set all the backup related settings including log setup.
To change the settings while the system is installed and in production later, please use the tool
7db and the logsetup sub-command. Complete guide to 7db tool is in the appendix of
Deployment Guide.
23.3.5 Managing backup levels
By default the system is in default state, no automated backups at all. Any change to that state
would require more resources and administration that should be planned separately.
In case one has changed the default settings – either by giving such install parameters or
issuing the needed commands after the installation - the following operations return the initial
state:
1) stop circadian backups
2) set logging to circular mode
This implies that the default state means circular logging without circadian backups.
23.3.6 File system settings for the database
There are three elements that require – optimally separate – disk space:
1. databases
a. measurement database
b. management database
c. security database
2. database logs
3. database backups
Naturally the backups must be stored separately from the logs and the databases, otherwise
the value of the backups reduces significantly. The databases and the related logs are expected
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.
23.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.