backup_state
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.
-
You have the server permission Backup.
-
You have started a backup (see: backup_start).
backup_state
OK
...
...
|
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 |
|
Max Used Data Page |
Page number, use this number to compute the amount of space that should be at least available in the target system for the data pages (page number * 8 KB) |
|
Converter page count |
Converter page count, use this number to count the converter size |
|
Redo Transactions Read |
|
|
Redo Transactions Done |
In the event of errors, see Reply Format.
Database Administration, Backing Up Data, Backing Up Log Entries