Teradata Backup: Best Practices for Teradata Backup and Restore

Special Offer: Purchase Handy Backup with a discount up to 30%!

Teradata backup presumes saving Teradata base content to another place, either to recover it when a need will emerge or to create a new copy of Teradata backup tables for cloning, replicating or clustering. Handy Backup allows automating any Teradata backup strategy by utilizing the "Database" plug-in.


Small Windows Logo Download for Free

Version 8.5.3 , built on March 5, 2024. 116 MB
30-day full-featured trial period

Teradata Backup Solution

Teradata Backup Tools

To perform backup of a Teradata database, all you need is ODBC backup tool software like Handy Backup, which includes the "Database" plug-in. Additionally, you'll need an ODBC driver (not bundled with Handy Backup) to enable Teradata usage as the Windows data source.

Note that the possibility of Teradata hot backup, e.g. of backing up Teradata tables without stopping processing the information by Teradata DBMS, is completely a matter of an ODBC driver. Handy Backup itself allows both hot and cold Teradata backup!

Advantages of Teradata Backup with Handy Backup

To help users realizing best practices for Teradata backup and restore, Handy Backup contains some crucial advantages over typical Teradata backup scripts and tools, allowing automating and controlling almost each step of backup process.

  • Saving Teradata backup in native format, allowing easy cloning and viewing backup data;
  • Providing options of full, incremental, differential and mixed backup, saving time and space;
  • Running other programs before or after backup, e.g. to stop and restart a Teradata server;
  • Scheduling tasks by periods from minutes to months, or by events such as user logon/logoff;
  • Keeping different versions of the same backup, compressing and encrypting backup data.
Scheduling Teradata Backup

Where I Can Store My Teradata Backups with Handy Backup?

Depending of your edition of Handy Backup, you can use many different storages for Teradata backup database. The table below presents the short list of the possible storages.

Storage TypesSupported Storages
Local drivesAny drive mounted to a computer
External drivesExternal USB drives (possible auto-starting a task)
FTP serversFTP, SFTP and FTPS storages with SSL
NAS unitsMapped drives or network resources
Network drivesMapped or shared network drives
Network machinesFor network editions – local drives on other PCs
Cloud servicesAmazon S3, Dropbox, Google Drive, OneDrive etc.

The Handy Backup team constantly expands the list of storage plug-ins available for saving data copies!

How Handy Backup Works as a Teradata Backup Solution?

To create a new task realizing and automating your Teradata backup strategy, please follow the next instruction, as well as corresponding sections or the User Manual.

  1. Open Handy Backup and create a new task using a button or a main menu item.
  2. Select a backup task on the Step 1, then go to Step 2 and double-click on the Database plug-in.
How to backup Teradata with Database plug-in
  1. Select the "Teradata" option from the list of the registered ODBC drivers by marking a checkbox.
How Handy Backup works as a Teradata Backup Solution
  1. You can also check/uncheck boxes on the right panel for particular Teradata backup tables.
  2. Then click the "OK" button and return to the task creation. Select a data storage on the Step 3.
  3. Now you may create your Teradata backup task as any other, according to the User Manual.

Note: If you need a "cold" backup in automated mode, instruct Handy Backup to run a command stopping the Teradata DBMS before the task. Then set up to run a command restarting the server after the task will complete its job. You can do it on the Step 7 in advanced mode, or later in task properties.


Recovery from Teradata Backup

To create a recovery task for Teradata backup, you may create it as described for backup tasks, only selecting a restore task type on the Step 1 and a backup storage on the Step 2. Select the backup.hbi index file to restore your Teradata backup at its original location.

Small Windows Logo Download for Free

Version 8.5.3 , built on March 5, 2024. 116 MB
30-day full-featured trial period

Handy Backup is the perfect Teradata backup solution, allowing securing and replicating your Teradata projects.
To get a personal experience with it, download just now a 30-days trial version with a full set of functions, which is completely free for you!

Who uses Handy Backup?