Defining a Backup Template for Complete Data Backup to a File


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 File for a complete data backup.

You can choose where you want to store this file in the system. 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 or name that includes blank characters, these must be written in quotation marks in the DBM command. The leading quotation mark must be preceded by a backslash (\).

The Database Manager stores the backup template internally. Only when the backup template is used for a backup does the file that contains the backup become visible in the system.

To read the prerequisites, see Database Manager CLI, medium_put

See also:

Concepts of the Database System, Backing Up and Restoring


You want to define a backup template with the following properties for complete data backup:

Backup template name: DemoDataCompl
Data carrier (device/file): Backups 2005\Data\completeDataJan
Backup type: complete data backup (
Size restriction: none (
Block size:
Overwrite: NO


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

>dbmcli -u OLEG,MONDAY -d DEMODB medium_put DemoDataCompl \"Backups 2005\Data\completeDataJan" FILE DATA 0 6 NO



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

You can now start a complete data backup using this backup template.

See also:

Concepts of the Database System, Backing Up Data

Database Manager CLI, backup_start