The Scenario - Teradata Database

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)