SAVE RESTORE POINT TO ARCHIVE

Eon Mode only

Saves an in-database restore point to an archive. After the restore point is saved, you can revive the database to the state at which the restore point was saved. For details on reviving your database from a restore point, see Revive from a restore point.

Syntax

SAVE RESTORE POINT TO ARCHIVE archive-name

Arguments

archive-name
Name of the archive to which the restore point is saved.

Privileges

Superuser or archive owner

Examples

The following statement saves a restore point to the verticadb archive:

=> SAVE RESTORE POINT TO ARCHIVE verticadb;
SAVE RESTORE POINT

To view all restore points in the database, query the ARCHIVE_RESTORE_POINTS system table:

=> SELECT * FROM ARCHIVE_RESTORE_POINTS;

                  id                  |         save_time          | index |  archive  |  state 
--------------------------------------+----------------------------+-------+-----------+----------
 2616f6cd-e98c-472c-8d5c-a7f459dff82b | 2021-12-10 10:19:58.565311 |     1 | verticadb | COMPLETE
 116066cc-29cb-4ce5-9a27-170538ba95cf | 2021-12-06 11:02:48.059941 |     2 | verticadb | COMPLETE
(2 rows)

See also