Skip to main content
Version: 20 R7 BETA

RESTORE INFO

RESTORE INFO ( selector ; info1 ; info2 )

ParameterTypeDescription
selectorIntegerType of information to get
info1Integer, DateValue 1 of the selector
info2Text, TimeValue 2 of the selector

Description

The RESTORE INFO command gets information related to the last automatic database restore.

Pass the type of information to get in selector. You can use one of the following constants, placed in the “Backup and Restore” theme:

ConstantTypeValue
Last restore dateLongint0
Last restore statusLongint2

The type and content of the info1 and info2 parameters depend on the value of selector.

  • If selector = 0 (Last Restore Date), info1 returns the date and info2 the time of the last automatic database restore.
  • If selector = 2 (Last Restore Status), info1 returns the number and info2 the text of the status of the last automatic database restore.

Note: This command does not take manual database restores into account.

See also

RESTORE