Download User Guide - Electronic's Time

21 Data Backup in ATS8600
One of the main features of the main database is easy data maintenance. ATS8600 uses the standard
MS SQL 2008 database. This enables you to integrate ATS8600 into internal company processes of
data back-up.
The production database contains current configurations and event history for the time period defined
for the particular project. The time period of the history saved influences the hardware requirements
of the server (memory and hard disks). This database is backed up regularly in order to be available in
case of a server failure. If backups are enabled, ATS8600 backs up all data each day at 11 p.m. If you
need to set up back-up intervals or back-up methods, contact your database administrator.
To backup the production database, set the backup. In Tools, select the Settings module. After the
module starts, select System settings. In Back-up, enter the following back-up attributes:
1. Enabled - select Yes to run the automatic back-up according to preset parameters.
2. Directory – folder on the database server where database backups will be stored.
Figure 21-1 Setting of back-up parameters
After saving the settings, automatic ATS8600 database backups are activated. Files with database
backups are stored on the server in the defined folder. The complete backup files always contain the
last three backups. These files are overwritten automatically and continuously.
Note:
We recommend using this method to back up the database, only if the installation runs the free MS
SQL Express edition that does not include automated database jobs. If the standard database server
edition, which makes it possible to create automatized database jobs, is available for the installation,
we recommend using its jobs to set the backup. This edition offers more detailed back-up settings
that can help optimize the database workload in case of large back-up files. To create the database
jobs, consult the database server administrator.
217