An all-AMPs archive on one or more partitions of a table is supported: it is not necessary to perform a full-table backup and restore. The ability to select partitions from PPI tables is limited to all-AMP archives. Dictionary, cluster, and journal archives are not supported.
Use partitioning to:
- Archive only a subset of data and avoid archiving data that has already been backed up. (This can minimize the size of the archive and improve performance.)
- Restore data in a table that is partially damaged.
- Copy a limited set of data to a disaster recovery machine or to a test system.
Before using this feature, read Potential Data Risks When Archiving/Restoring Selected Partitions.
For information about the keywords that are specific to archiving and restoring selected partitions of PPI tables, see Using Keywords with ARCHIVE and Archive Selected Partitions of PPI Tables.