Entering content frame

Background documentation Backup Strategy Locate the document in its SAP Library structure

One key element of the security concept for your database system is the making of regular backups of your data.

Note the following recommendations when designing your backup strategy:

·        Perform a complete data backup on each day of production.

·        If you cannot or do not want to make a complete data backup every day, you should at least make an incremental data backup on each day of production use of the database.

Note

Note that, if you are restoring data, a more up-to-date data backup means that fewer log entries need to be reproduced.

·        Activate automatic log backups (autosave log mechanism).

·        If you do not use automatic log backups, then make regular checks to see whether there is enough memory in the log area. Also make at least one interactive log backup on each day of production use of the database.

Caution

If new log entries cannot be written to the log area because there is not enough memory, the database stops.

·        Archive the version files written during a log backup to a medium of your choice at regular intervals. Once the files have been archived successfully, you can delete the archived version files, so ensuring that there is enough space available in the directory for version files.

·        Tapes containing data or log backups should not be directly overwritten with the next backup. If you retain, say, the last four backup generations, it may be possible to use an older backup if a media failure occurs.

 

Leaving content frame