15.00 - The Scenario - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

The Scenario

Database and table dumps and restores are a time consuming process. To minimize this problem, you can isolate large tables in their own databases in order to isolate their backup and restoration. Otherwise, when tables of this magnitude are mixed with much smaller tables, you have two choices:

  • Back up the large table in one pass and then backup the remaining tables in a second pass.
  • Back up the entire database at once, which takes a very long time to complete (and even longer to restore)