Backup Software / Features / Database Backup Software / 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.
Version 8.1.3, built on 6 August 2020 106 MB
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!
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.
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.
The Handy Backup team constantly expands the list of storage plug-ins available for saving data copies!
Version 8.1.3, built on 6 August 2020. 106 MBBackup Software from Novosoft LLC. 249 USD per license.
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!
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.
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.
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.
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!
Copyright © 2004-2020 Novosoft LLC. All rights reserved. Handy Backup software.10685-B Hazelhurst Dr., Houston, TX 77043, United States Tel.: +1 (707) 703-13-11
Back to Top