Backing Up a Database

For general information about the database system see
Database System
Concepts.
There are
two types of backup –
Data Backups and
Log
backups
.
· Backup strategy for the content server database with SAP content only:

Because in this case the content is not changed, we recommend that you make a full data backup of the content server database (save date) after installation.
· Backup strategy for a content server database with customer content:
The backup strategy depends on the size of the content server database and on the volume of changes per day and week.

We recommend that you make a full data backup of the content server database once a week. If a large volume of content is changed or added in the course of a full data backup, rebuilding the log entries make may take longer in any recoveries carried out later. Therefore, it may be sensible to make incremental data backups on some days or even daily.
The
Log Area should be
backed up using the automatic log backup in
Version
Files.
Backup generations (data and log backups) should remain available for at least four weeks. The fifth full backup is then sufficient to overwrite the first full backup.This means you can recover a data backup that is four weeks old.
· Backup Strategy for the Cache Server
The cache
server gets its data from the connected content servers. The cache
server runs in the
Overwrite Mode for the
Log Area (in older versions the log mode DEMO), that is, the log area is
not saved.
In overwrite
mode the restart function following a database failure and intact
Volumes are
kept.
After installing the Cache Server, but before using it in a productive system, make a full data backup, and a copy of the file cacheserver.ini. In the case of a recovery, you can then use this full backup to restore the initial status of the Cache Server.
If there is
a volume failure, you have to first
make sure that an error-free disk periphery is available. Then you can
use the database manager GUI, for instance to
Recover the
Data.
See also:
Concepts of
the Database System,
Backing Up and
Restoring
0350067 Administration Content Server/SAP DB
0351647 Cache Server Administration
0354819 Composite note SAPSECULIB
0361123 SAP Content Server and Security
