Skip to main content
Version: 20 R7 BETA

BACKUP INFO

BACKUP INFO ( selector ; info1 ; info2 )

ParameterTypeDescription
selectorIntegerType of information to get
info1Integer, DateValue 1 of the selector
info2Time, TextValue 2 of the selector

Description

The BACKUP INFO command gets information related to the last backup performed on the database data.

Pass the type of information to get in selector. The type and content of the info1 and info2 parameters depend on the value of selector. You can use one of the following constants, placed in the “Backup and Restore” theme:

ConstantTypeValueComment
Last backup dateLongint0info1 returns the date and info2 the time of the last backup.
Last backup informationLongint5info1 returns the last backup duration in milliseconds (longint) and info2 the last backup begin timestamp (string, see formatting details in the Timestamp command)
Last backup statusLongint2info1 returns the number and info2 the text of the status of the last backup
Next backup dateLongint4info1 returns the date and info2 the time of the next scheduled backup

See also

RESTORE