backup or archive command

Database
Enthusiast

backup or archive command

Does Teradata DBMS have a command-line function for creating offline backups, something roughly equivalent to "pg_dump" for Postgres or "mysqldump" for MySQL ?

Or perhaps a GUI-based backup, like right-clicking a database name in SQL Server Management Studio?

Thank you.
Tags (2)
1 REPLY
Enthusiast

Re: backup or archive command

Hi,

Backups and recovery are the strong points of Teradata. You can dump and restore data, with many check conditions  as per your requirements.

Unlike other vendors that I worked before , here it is having umpteen advanced  features.

Restore DATA TABLES (abc) ALL....Restartability of archiving is robust. 

Few commands that I know are Rollback, rollforward,restore,logdata, enable encryption, copy,checpoint,build,archive,analyze,release lock etc.

It helps in DR plan.

Hope it helps.

Cheers,

Raja