Teradata Backup: Best Practices for Teradata Backup and Restore

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.


Free Download

Version 8.5.0, built on September 19, 2023
116 MB

Teradata Backup Solution

Teradata Backup Tools

All you need for backup of a Teradata base is an edition of Handy Backup containing the "Database" plug-in. Another requirement is an ODBC driver (not included in Handy Backup), allowing using Teradata 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 drives Any drive mounted to a computer
External drives External USB drives (possible auto-starting a task)
FTP servers FTP, SFTP and FTPS storages with SSL
NAS units Mapped drives or network resources
Network drives Mapped or shared network drives
Network machines For network editions – local drives on other PCs
Cloud services Amazon S3, Dropbox, Google Drive, OneDrive etc.

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

Recommended Solution

Handy Backup Small Business

Version 8.5.0, built on September 19, 2023. 116 MB
Backup Software from Novosoft LLC. 249 USD per license.

Handy Backup Small Business

The Small Business edition contains a Database plug-in and a full set of storage plug-ins allowing you realizing almost any strategy for automatic Teradata backup! Free 30-days trial version!

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.

Free Download

Version 8.5.0, built on September 19, 2023
116 MB

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!

0 comments

    Who uses our backup software?