All Forums Database
TrackingDaily 9 posts Joined 09/12
06 Dec 2013
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.

Raja_KT 1246 posts Joined 07/09
06 Dec 2013

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

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.