RESTORE BACKUP DATABASE
Syntax
RESTORE BACKUP DATABASE database_name [GENERATION generation] [INDEX index] [TIMESTAMP timestamp]
Privileges
RESTORE
Description
Starting from the information returned by the LIST BACKUP DATABASE
command, you can restore a database with the RESTORE BACKUP DATABASE command. During a RESTORE, the database database_name will not be available. The TIMESTAMP option is usually used to restore a specific database back in time, but the GENERATION and INDEX options can also be used.
Return
OK string or error value (see SCSP protocol).
Example
> RESTORE BACKUP DATABASE db1.sqlite TIMESTAMP 2023-02-06T15:53:30Z