I am very new to teradata. recently I have installed teradata 15 on my machine & trying to work with it. Created few procedures & functions. Now My problem is I have to take the backup of one database on my terdata machine.
I don't find any proper links to get this backup done:
1)How can i backup complete teradata database from the CLI.
As I dont have any tools like BAR,TARA etc. I think those are paid versions, which I can't effort as I am learning with freewares.
So i request the experts to kindly provide me the steps how can i get a backup of teradata database from the CLI.
Thanks in advance
Create a file like this:
ARCHIVE DATA TABLES (mydb) ALL,
And then run that using arcmain < this_file from the linux terminal (the backup tools simply provide GUIs for that).
Check the manuals for details: http://www.info.teradata.com/HTMLPubs/DB_TTU_15_00/index.html#page/Database_Administration_Tools/B03...
Thanks for the information. Now I can able to get the backup of my database. I m having a question regarding this
here we are archiveing only the tables it seems. what about the procedures, functions etc. Everything will be with the myfile itself.I mean can I use this backup directly on the other machine.
Every object other than Database and Users are trated as Tables in Teradata.the above backup script includes tables, views, macros, SPs, triggers,UDFs.
BTW both database and user are basically databases in Teradata.