Defining a Backup Template for Log Backup to a Pipe

Use

You use a backup template of the PIPE type when you want to transfer data to other programs or transmit it from one computer to another. So you have the option of using not only the backup tools directly supported by the MaxDB database software but also of connecting backup tools from other providers, if they are capable of reading data from pipes.

You log on to the Database Manager CLI as a DBM operator, connect to the database instance for which the backup template is to be created and define a backup template of type Pipe for a log backup.

You can only use a backup template of type Pipe for interactive log backup, not for automatic log backup.

Depending on your operating system, you can choose where in the system you want to store the pipe. If you enter a relative path, it is interpreted as relative to the working directory of the database instance. The specified directory must already exist. If you enter a path that includes blank characters, these must be written in quotation marks in the DBM command. Be sure to note your operating system’s naming rules for pipes.

The Database Manager stores the backup template internally. Only when the backup template is used for a backup is the pipe created and opened and the data written to it.

To read the prerequisites, see Database Manager CLI, medium_put

See also:

Concepts of the Database System, Backing Up and Restoring

Scenario

You want to define a backup template with the following properties for log backup to a pipe:

Backup template name: DemoPipeLog
Data carrier (device/file): \\.\pipe\testpipe
Type:
PIPE
Backup type: interactive log backup (
LOG)

Call the Database Manager CLI, log on as DBM operator OLEG with password MONDAY, connect to the database instance DEMODB and define a backup template with the properties listed in the scenario:

>dbmcli -u OLEG,MONDAY -d DEMODB medium_put DemoPipeLog \\.\pipe\testpipe PIPE LOG

OK

Result

You have created the backup template DemoPipeLog for the database instance DEMODB.

If you have already made a complete data backup of DEMODB, you can now start an interactive log backup using this backup template.

See also:

Log Backup to a Pipe

Concepts of the Database System, Backing Up Log Entries

Installation Manual, Connecting Backup Tools from Other Providers

Database Manager CLI, backup_start