Background documentationbackup_state Locate this document in the navigation structure

 

With this command you can display the current status of the backup operation.

You can execute this command while a backup operation is in progress. To do this, open a second command prompt and log on there again to the database on which the backup operation is running.

Prerequisites

Structure

backup_state

Result

OK

...

...

Values for the Reply Fields

Value

Description

Date

Date

Time

Start time of the backup

Server

Name of the database computer

Database

Name of the database

Kernel Version

Version of the database kernel

Pages Transferred

Number of pages transferred

Pages Left

Number of pages still to be transferred

Volumes

Number of data carriers used

Medianame

Name of the backup template

Location

File or device name

Errortext

Error message text

See also:

Messages documentation

Label

Backup ID

Is Consistent

Only for data backup: Backup is internally consistent

First LOG Page

For data backup: First page of the log backup to be read

For log backup: First page saved in the log area

Last LOG Page

For log backup only: Last page saved in the log area

DB Stamp 1 Date DB Stamp 1 Time

Time stamp for the first page of the log backup

DB Stamp 2 Date DB Stamp 2 Time

Time stamp for the last page of the log backup

Page Count

Total number of pages backed up

Devices Used

Number of backup devices used

Database ID

Database ID used to identify data and log backups that belong together

In the event of errors, see Reply Format.

More Information

Database Administration, Backing Up Data, Backing Up Log Entries