Basics of Data Restoration | Teradata Vantage - 17.00 - 17.05 - Basics of Data Restoration - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine Node Software Migration Guide

Advanced SQL Engine
Teradata Database
Release Number
Release Date
June 2020
Content Type
Publication ID
English (United States)

Every site has established procedures for restoring data. Use the procedures established as standard for your site.

A full system restore requires both DBC All and DBC Only backups.

Some databases and objects cannot be restored on the destination system unless the related feature has been enabled on the destination system prior to restoration. Temporal and Columnar Partitioning as well as any other feature that must be purchased separately fall into this category.

If the DBC Only restore job fails, the entire procedure needs to be repeated starting at performing a sysinit of the system again. If a data restore job fails, that job can be repeated after the problem is fixed.