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.
Download for Free
Version 8.5.8 , built on October 31, 2024. 118 MB
30-day full-featured trial period
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.
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 Types | Supported 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
$249 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.
- Open Handy Backup and create a new task using a button or a main menu item.
- Select a backup task on the Step 1, then go to Step 2 and double-click on the Database plug-in.
- Select the "Teradata" option from the list of the registered ODBC drivers by marking a checkbox.
- You can also check/uncheck boxes on the right panel for particular Teradata backup tables.
- Then click the "OK" button and return to the task creation. Select a data storage on the Step 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.
Download for Free
Version 8.5.8 , built on October 31, 2024. 118 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!