Regular Administration Tasks 
There are a number of administration tasks that you have to perform regularly in a production system.
If you are using the database instance in a production system, we recommend that you monitor the database instance (see Monitoring).
The following table is an example of scheduling regular administration tasks. Depending on how large you configured your database instance to be and how much of its capacity is in use, these administration tasks may need to be performed more or less frequently than in this example.
Example: Scheduling Regular Administration Tasks
Action |
Occurrence |
Comments |
Complete data backup (see Backing up Data) |
On each productive day |
If you cannot or do not want to perform a complete data backup every day, then you should perform at least an incremental data backup on each productive day. The more current the last data backup is, the fewer log entries the database system has to import again if you need to restore the database instance. |
Once a week |
Only necessary for log backups on data carriers of the File type |
|
Log backup (See Backing up Log Entries) |
Once a week |
Only necessary if automatic log backup is switched off
We recommend that you activate automatic log backup. Log backups are the prerequisite for a complete backup history. |
Once a week |
We recommend that you check the database structures at times when the database load is low, or using a system copy. |
|
Update SQL Optimizer Statistics |
Once a week |
|
See also: