Teradata Backup: Best Practices for Teradata Backup and RestoreTeradata 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 ![]() Teradata Backup ToolsAll 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 BackupTo 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.
![]() 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.
The Handy Backup team constantly expands the list of storage plug-ins available for saving data copies! Recommended Solution![]() Version 8.5.0, built on September 19, 2023. 116 MB Handy Backup Small BusinessThe 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.
![]()
![]()
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 BackupTo 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 Handy Backup is the perfect Teradata backup solution, allowing securing and replicating your Teradata projects. |
0 comments