Hey all,

.logon 127.0.0.1/dbc,dbc;
     
ARCHIVE DATA TABLES
     (RETAIL) ALL,
     RELEASE LOCK,
     FILE=ARCHIVE;
.logoff;

Hi,
I want to archive teradata database table. I am using above script.
after executing the script. I got following error.

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.

Hello Folks,

Hey all, new to teradata.
I have to move a database from one teradata server to another.
Used Arcmain to do an archive, successful, but for the life of me can't find out where that archive actually exist so i can copy over to the new server and do a restore.
Using TeraData13 on SUSE 10

All All,

I have a PPI table paritioned by end_dt

Hello folks,

I am reviewing some documentation and have done some research on the ability to protect my data using the Archive utility. My source of the documentaiton is here... http://www.info.teradata.com/edownload.cfm?itemid=101680007

For my situation, I need to have a few datasets (7 at most) to recover from. So given the following Archive script...

-----
LOGON DBCID/UID,PW;
ARCHIVE DATA TABLES (MYONLINEDATA) ALL,
RELEASE LOCK,
FILEDEF=(tddumps,/var/tddumps/dump.%UEN%.out);
LOGOFF;
-----

Hello,

I am trying to set up our Development environment, and would like to take a copy of the Production envirnment and put in in Dev. The catch....I don't want 100% of all records in the tables. I would like only x% to populate the Dev tables.

Does anyone know if there is a way to do this?