The terms backup and dump are often used interchangeably with archive.
Restore, which is a specific Teradata ARC keyword and the name of a Teradata ARC operation, is part of the recovery process. In addition to restore, recovery entails other operations, such as returning data tables to their state following their modification (called rolling forward), returning data tables to the state they were in before they were modified (called rolling back), and so on. For further explanation, see Archive/Recovery Control Language. There is no Teradata ARC statement called “recover.”
The difference between copy and restore is in the kind of operation being performed:
- A restore operation moves data from archived files back to the same Teradata Database from which it was archived or to a different Teradata Database so long as the database DBC is already restored.
- A copy operation moves data from an archived file back to a Teradata Database, not necessarily to the same system, and creates a new table if one does not already exist on the target database. When a selected partition is copied, the table must exist and be a table that was previously copied as a full-table copy.