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.

Get Teradata Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.