Show TOC

Backing Up DataLocate this document in the navigation structure


If a hardware problem or other error occurs, you return your database to a consistent state (restore) using backups. To speed up the backup process, you can back up data to several data carriers in parallel.


Regularly back up the data from your database to data carriers.

Use parallel backups whenever possible.


Check the database structures of your database before carrying out a complete data backup.

More information: Checking Database Structures

  • 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 have created a backup template.

    If you want to backup to several data carriers in parallel, you need a backup template for parallel backups.

    More information: Defining Backup Templates

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

  • If you are using a third-party backup tool, connect it.

    More information: Installation Manual, Connecting Third-Party Backup Tools

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


You cannot start an incremental data backup during a complete data backup, or a complete data backup during an incremental data backup.

  1. Select the database in the explorer tree.

  2. In the context menu of the database, choose Start of the navigation path Administration Tasks Next navigation step Backup... End of the navigation path

  3. Choose the backup type:

    • Complete Data Backup:

      You back up the entire data area.

    • Incremental Data Backup:

      You back up all data in the data area that has been changed since the last complete backup.

  4. Select the backup template.

  5. Start the backup.

    The system shows the current status of the backup procedure in the status window.

    On the Backup Results tab page, the system shows the data carriers that have been used up to now.


In the Actions view, the system shows the backup steps performed so far.

More information: Actions (View)


You perform a complete data backup with the following backup template:

Table 1: Example of a Backup Template for a Complete Data Backup



Name of the backup template


Backup type


Data carrier type


Data carrier (Device/File)


Note that if 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_COM

Size of data carrier

No restriction (blank or 0)

Block size

8 pages



More Information

Database Administration, Backing Up Data