Procedure documentationActivating or Deactivating Automatic Log Backup Locate this document in the navigation structure

 

If you have activated automatic log backup, the database system backs up the redo log entries automatically.

Backups of redo log entries (log backups) are required so that the database can be restored to the desired point in time after certain system breakdowns. Redo log entries are where the database system logs all changes that database users have made to data.

Regular log backups are also important for another reason: The database system can overwrite a log segment of the log area with a new entry only after it has been backed up.

Note Note

You can also back up the redo log entries manually.

More information: Backing Up Log Entries

End of the note.

Prerequisites

  • You are logged on to the database as the database system administrator or as a DBM operator with server authorization for performing backups.

    More information: Glossary, Server Permission

  • You can only back up redo log entries after at least one complete data backup has been carried out.

    More information: Backing Up Data

  • You have created a backup template for log backups.

    Note Note

    For automatic log backup, you cannot use pipes.

    End of the note.

    More information: Defining Backup Templates

  • The database is in the ONLINE or ADMIN operational state.

  • Overwrite mode for the log area is switched off.

    More information: Changing Log Settings

  • Only on Microsoft Windows:

    If you want to back up data to a data carrier on a remote computer, perform the steps described in Database Administration, Backing Up and Restoring Data with Remote Computers.

Procedure

  1. In the context menu of the database, choose Administration.

  2. Open the Overview tab page.

  3. Choose Automatic Log Backup.

Activating Automatic Log Backup
  1. Select Activate Automatic Log Backup.

  2. Select the backup template.

  3. Select when you want the system to run log backups.

    • Create log backup when log segment is full (Default)

    • Create a log backup every <number> seconds

  4. Choose Activate.

Note Note

For log backups to data carriers of the file type, you have to archive the backup files regularly. To do this, use the database tool Database Manager CLI.

More information: Database Manager CLI, archive_stage

End of the note.
Deactivating Automatic Log Backup
  1. Select Deactivate automatic log backup.

  2. Choose Deactivate.

Switching to a Different Backup Template
  1. Select Restart automatic log backup

  2. Select the backup template.

  3. Choose Restart.

Example

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

Example of a Backup Template for a Log Backup

Property

Value

Name of the backup template

MYLOG

Backup type

LOG

Data carrier type

FILE

Data carrier (Device/File)

DEMODB_MYLOG

If you do not enter an absolute path, then the database system uses the run directory of the database.

Example: C:\Documents and Settings\All Users\Application Data\sdb\data\wrk\DEMODB\

More information: Run directory

Size of data carrier

No restriction (blank or 0)

Block size

8 pages

Overwritable

No

The system writes continuous log backups to the following backup files:

DEMODB_MYLOG.001

DEMODB_MYLOG.002

DEMODB_MYLOG.003

DEMODB_MYLOG.004

DEMODB_MYLOG.005

More Information

Database Administration, Backing Up Log Entries