Procedure documentationBackup Templates and Data Carriers Locate this document in the navigation structure

 

Before you can back up data and log entries to a data carrier, you must define backup templates. In the properties of a backup template you specify, among other things, the backup type, and the type of data carrier that you want to use. You can use the same backup template more than once.

Backup Template Properties

Property

Description

Name

The name of the backup template has no influence on the name of the backup created later using this backup template.

Backup Type

  • Complete data backup

  • Incremental data backup

  • Log backup

Device Type

Data carrier type

  • File

  • Tape

  • Pipe

    Note Note

    For automatic log backups, you cannot use pipes.

    End of the note.

Backup Tool

Only if you are using a third-party backup tool

Specify the backup tool:

  • BACK: Backint for Oracle or Backint for MaxDB

  • NSR: Networker

  • TSM: TSM

More information: Database Administration, Using Third-Party Backup Tools

Device/File

Depending on the backup type enter the required information:

  • Name of the tape device in the operating system

  • Path and file name of the file in the file system

    Caution Caution

    If you do not enter a full path here, the system stores your backup in the run directory of the database.

    More information: Glossary, Run Directory

    End of the caution.
  • Path and name of the pipe

We recommend that you do not use the same data carrier for several databases.

For log backups to files, the system adds a sequence number to the name of each new backup file. It assigns the numbers sequentially as long as the history of the log backups is not interrupted. If the log backup history is interrupted (for example after the database was initialized), the system starts numbering at 001 again.

It also uses sequential numbers if you carry out multiple log backups for one database onto different data carriers, and thus to files with different file names.

Example Example

LogUri.001

LogKai.002

LogOleg.003

LogUri.004

LogUri.005

End of the example.

If automatic log backup is switched on, the system stores all backup files under the same file name using a sequence number.

Example Example

DEMODB_MYLOG.001

DEMODB_MYLOG.002

DEMODB_MYLOG.003

DEMODB_MYLOG.004

DEMODB_MYLOG.005

End of the example.

You can also back up to data carriers on remote computers. More information: Database Administration, Backing Up and Restoring Data with Remote Computers

Size

There is no size restriction in default mode.

The size of log backups to files is calculated as the size of a log segment (general database parameter AutoLogBackupSize) plus the space required by system information.

More information: Database Administration, General Database Parameters

Compressed

For backup templates of the FILE and PIPE types only

Specifies whether the backup is compressed

Overwrite

For backup templates of the FILE type only

Specifies whether the backup file can be overwritten

We recommend that you do not overwrite a backup with the backup that immediately follows it. Always keep an older version of the backup.

Block Size

Block size that the system uses to write backups to the data carrier.

Autoloader

Select this option if you want to use a tape device with an automatic tape loader.

OS Command

For backup templates fo the TAPE type only

Operating system command for backing up to tape devices

Encryption

Prerequisites: license for SAP Cryptolib (only available in SAP systems), private-public key pair has been created using sapgenpse

  • Algorithm

    Available encryption algorythms: DES, AES

  • Owner

    Private key owner (see X.509 certificate)

For more information, see Encryption.

The following table shows the different types of data carriers you can use for data and log backups.

Data carrier types

Type

Suitable for the Following Backup Types

Comments

FILE

  • Data backups

  • Log backups

  • Automatic log backups

Do not create backups on data carriers of the FILE type that are located on the same hard disk as the volumes of the database. Always carry out backups to a separate hard disk.

If your data carriers are located on the same computer as the database, regularly copy the backups to other computers or data carriers using operating system commands.

TAPE

  • Data backups

You can use autoloaders.

Do not use tapes more often than is recommended by the manufacturer.

On Unix:

  • Make sure you address the correct device driver.

  • Use a rewind tape.

PIPE

  • Data backups

  • Manual log backups

    Note that automatic log backups to pipes are not possible.

On Microsoft Windows, the pipes are created by the database kernel.

On Unix, the pipes are not created by the database kernel:

  • For backups without third-party backup tools, you must create the pipe explicitly before you start the backup.

  • For backups using third-party backup tools that are not directly supported by SAP MaxDB, you must create the pipe explicitly before you start the backup.

  • For backups using third-party backup tools that are directly supported by SAP MaxDB, the pipe is created by the database system during the backup. The pipe must not exist beforehand.

Before you carry out a log backup to a pipe without a third-party backup tool or with a third-party backup tool not directly supported by SAP MaxDB, first set the value of the special database parameter EnableLogBackupToPipe to YES. This ensures that the system can overwrite the log entries in the log area that have already been written to the pipe. Note that the system does not check whether the log backup to the pipe was successful. More information: Database Administration, Special Database Parameters

Procedure

To create backup templates, use Database Studio, Database Manager CLI, or CCMS (in SAP systems only). More information:

Example

Example of a Backup Template for a Complete Data Backup

Property

Value

Name of the backup template

COM

Backup type

COMPLETE DATA

Data carrier type

FILE

Data carrier (Device/File)

DEMODB_COM

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

Overwritable

Yes

Example of a Backup Template for a Log Backup

Property

Value

Name of the backup template

DEMODB_LOG

Backup type

LOG

Data carrier type

FILE

Data carrier (Device/File)

DEMODB_MYLOG

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

Overwritable

No

More Information

Backing Up Databases