Show TOC

backup_template_showLocate this document in the navigation structure

Use

Use this command to display the properties of the specified backup template or of all backup templates defined for the current database.

In a bridge scenario, the output also contains the name of the successor template used for the data backup.

Prerequisites

You have the server permission Backup.

Structure

backup_template_show <backup_template_spec> | ALL

<backup_template_spec> :: = NAME <backup_template>

Option

Description

<backup_template>

Name of the backup template whose properties you want to display

Result

OK

NAME <backup_template>

CONTENT <backup_type>

CREATIONDATE <date>

MODIFICATIONDATE <date>

TOOL NONE | <backup_tool>

BLOCKSIZE 8

[SUCCESSOR <successor_template>]

DATACARRIER

TYPE <data_carrier_type>

LOCATION <tape_device> | <path_and_name_of_pipe> | <path_and_name_of_file>

OVERWRITE NO

COMPRESSED NO

...

...

...

[CONTINUE]

In the event of errors, see Reply Format.

Example

dbmcli on DEMODB> backup_template_show NAME DemoDataCompl

OK

NAME DemoDataCompl

CONTENT DATA

CREATIONDATE 20100412154815

MODIFICATIONDATE 20100412154815

TOOL NONE

BLOCKSIZE 8

DATACARRIER

TYPE FILE

LOCATION C:\databackup

OVERWRITE NO

COMPRESSED NO

More Information

Database Administration, Backup Templates and Data Carriers