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)