Use this command to display information about the current status of the operation for checking a backup (see: recover_check).
You can execute this command while a backup check is in progress. To do this, open a second command prompt and log on there again to the database on which the backup is being checked..
You have the server permission Backup.
You have opened a service session (see: service_connect).
recover_state_check
OK
Returncode <value>
...
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 |