Backup and recovery

The purpose of the ARC utility is to allow for the archiving, restoring, and copying of database objects. To maintain data security and integrity, backing up data is a must. And when you damage or lose or want to restore the previous version of data, restore is required to be performed.

The following figure shows the high-level architecture of backup and recovery, or the BAR system:

We will start with advanced SQL and then will cover some recipes on Teradata ARC.