Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 13 Sep 2004 @ 10:21:20 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Question on Data Recovery
 
From:   Coffing Christopher L

Narrayan

Dropping a Database/User would mean that the Database/User had no tables or other objects within it so you would simply recreate the database/user. If you have an Archive of the database/user then you could restore it from backup.

In regards to tables... Oooooo! You will need to recover the data from backup. I do not believe there is anyway to recovery from the Transient Journals... Those are used for rollback so if you were in the middle of the update/delete you could abort the request and the table would rollback.

If you have already completed the tasks in deleting the data, then you will need to recover from backup....


Best Regards

Chris Coffing
AFKS O&M Lead Teradata DBA
Certified Teradata Master



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023