0 - 6 of 6 tags for recovery
Using ARCMAIN 
.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.

By hesham, 19 May 2014 | Tagged: arcmain archive recovery | 1 comment
Backup consistency

Hi all,

I am not seeing any information on this so I thought I'd ask the smart minds here ;-). Are Teradata backups consistent as at the backup start time or end time?

 

Thanks,

By cgswong, 24 Jul 2012 | Tagged: general backup recovery question | 1 comment
Connections to Teradata

Hi all,

 

I am new to Teradata (spooling up POC) and have thus far not been able to locate the infomation which I am seeking so beforehand I do apologize for such basic questions, but I would greatly appreciate some assistance.

 

By cgswong, 24 Jul 2012 | Tagged: general session backup failure recovery connection availability | 1 comment
Using a named pipe archive to copy a database from one system to another

Recently, I was presented with a situation to move several Terabytes of data from one machine to another. So FastExport/FastLoad really wasn’t feasible. I didn’t have the hard drive space to hold the flat files because they were so big. So then I tried to archive the database, but again, the archive file was too big.

By jim, 13 Oct 2011 | Tagged: archive arcmain recovery named pipe archive | 25 comments
How to recovert Teradate Query from Windows Standby

Hi,

I was running a complicated query using Teradata installed on my local laptop. But my laptop went to stand-by mode as it was closed. So, I had to re-boot my laptop. I have been running the teradata query for the last 8 hours and feel frustrated. Is there a way to recover whatever was done by the query and re-start from where it crashed?

By terasri, 05 May 2011 | Tagged: teradata query recovery crash | 3 comments
Teradata Backup and Recovery.

Hi all,

I am very new to Teradata.
Want to learn about Backup and Restore a Teradata Database.
Kindly somebody help me to get this.

Thanks in advance.

By Pankaj Babre, 16 Sep 2010 | Tagged: teradata backup recovery | 1 comment