Backing Up a Database

Use

Backup Types

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

Backup Concepts

  • Backup strategy for the content server database with SAP content only:

  • 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.

    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.

More Information

Concepts of the Database System, Backing Up and Restoring

Related Notes

0350067 Information published on SAP site Administration Content Server/SAP DB

0351647 Information published on SAP site Cache Server Administration

0354819 Information published on SAP site Composite Note SAPSECULIB

0361123 Information published on SAP site SAP Content Server and Security