Show TOC

Archiving Backup FilesLocate this document in the navigation structure


If automatic log backup is switched on, the database system continuously writes redo log entries to backup files (in chronological order). Thus the number of backup files on the hard disk keeps growing until there is no more storage space available.

If no more storage space for log backups is available on the hard disk, then after some time, no more storage space for redo log entries is available in the log area of the database either. This is because old redo log entries can only be overwritten by the system with new entries after they have been backed up. Exception: Overwrite mode for the log area is activated; but this is not recommended for production systems. If the database system cannot write any further redo log entries to the log area, it stops all running transactions. This means that the database is unavailable for users.

Therefore you need to ensure that there is always enough space available for log backups by moving your backup files to other data carriers (archiving).


Archiving Backup Files Manually

  1. Locate the backup files.

    More information: Backup Templates and Data Carriers


    You have defined the following backup template and activated automatic log backup:

    Table 1: Example of a Backup Template for a Log Backup



    Name of the backup template


    Backup type


    Data carrier type


    Data carrier (Device/File)


    Note that i you do not enter an absolute path, then the database system uses the run directory of the database, see Run directory.

    Example: C:\ProgramData\sdb\globaldata\wrk\DEMODB\DEMODB_LOG

    Size of data carrier

    No restriction (blank or 0)

    Block size

    8 pages



    Your backup files are located in the run directory of the database:






  2. Caution

    If automatic log backup is activated, the system backs up new log entries to the newest backup file even during archiving. To ensure that you only archive complete backup files, exclude the newest backup file from archiving.

    To archive the backup files, use operating system commands to move the oldest backup files to another data carrier.

Archiving Backup Files Automatically

If you use third-party backup tools, you can automate the archiving of backup files using Database Manager CLI or CCMS (only in SAP systems).

More information: