Backing Up a Database 

For general information about the database system see Database System Concepts.

Backup Types

There are two types of backup – Data Backups and Log Backups.

Security Concepts

·        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 proceed as described in Restoring Data.

Related Notes

0350067      Administration Content Server/SAP DB

0351647      Cache Server Administration

0354819      Composite note SAPSECULIB

0361123      SAP Content Server and Security