Restoring a Standard Backup - Teradata Vantage

Teradata® VantageCloud Enterprise

Teradata Vantage
Release Number
February 2024
English (United States)
Last Update
Product Category
Teradata Vantage
PrerequisiteSame-Site Restoration

Before attempting to restore a backup, make sure you meet the following prerequisites for same-site restoration:

  • The VantageCloud Enterprise site must be set up with Query Service and is configured for self-service support. If not available, raise a change request.
  • You must be a Console administrator (have TD-CUSTOMER-ADMIN role) to create partial backups or restore backup jobs.
  • Make sure the Console user exists in the database. Use Teradata username field on the User Settings tab of the Your account page. If the user does not exist, create one and grant permissions using the following commands respectively:
    • CREATE <username> as password=<password>, perm=<desired perm space>;
  • You have restore access rights on all databases and all tables on the system. This is to view all the objects in a backup. Use the following commands to grant privileges.
    • GRANT DUMP, RESTORE ON "ALL" TO <td-username>;
  • Grant create, alter, and drop permissions to the user.

    You should have the database credentials of the user, that is, <td-username> and its <password>. Make sure the <td-username> has drop/create/alter permissions on the target database to restore data to the target system. For example, to restore data to a database named dbcmngr on the target system, use the following command to give drop/create/alter permissions.

    • GRANT all on "dbcmngr" to <td-username>;
Cross-Site Restoration

For Cross-Site restoration, in addition to meeting the prerequisites of same-site restoration on the source site, you must also fulfill the following:

  • You must have Vantage 2.4.2 on both source and target sites.
  • Make sure the Console user exists on the target site. If the user does not exist, create a user using the steps mentioned in the same-site restoration prerequisites.
  • Grant create, alter, and drop permissions to the user on the target site.
  • The logged in user must have restore access rights on all databases and all tables on the target site.
Restoring Backups

Use the following procedure to restore backups.

  1. Log on to
  2. Select Data protection .
  3. Select Retained copies.
  4. Select the backup to restore, select , then Restore.
  5. Enter the Restore Job name.
  6. In the Target site, select the site to restore.
    By default, the current site is selected. For cross-site restoration, select a different site to restore the backup.
  7. Open the Settings tab and select the required option from the following scenarios.
    Option Details
    Continue on access rights violation The restore job proceeds even when the DUMP access rights violation occurs.
    Run as copy job Restores data into a database with a different internal database ID than the one in the backup set.
    Do not select this option when the database system is original, and the database ID matches with the saved backups.
    Rename objects during restore on the target site by adding a suffix. Select to add a suffix for renamed tables to differentiate from the original.
    Restore to a different database on the target site Select to choose the database from the available list.
    Skip statistics Select to skip collecting statistics during a backup or restore job.
  8. Open the Objects tab and select the required objects to restore using the respective checkboxes.
  9. Open the Selection Summary tab and make sure the selections you made are available.
  10. Select Save & Run.
  11. If requested, provide credentials, and select Save & Start.
  12. Open the History tab and check the Status of the restore job.
TroubleshootingRunning Failed Restore Jobs

If the job restoration fails or completes with errors, you can rerun the job. The steps to follow are:

  1. On the Jobs tab, select the failed job.
  2. On the Overview tab, select to view the details of errors.
  3. Make necessary changes on the Settings tab.
  4. On the Objects tab, select the failed objects and click Save.
    You can update or run only failed objects.
  5. Select , then Run.