Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 30 May 2012 @ 00:07:34 GMT


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


Subj:   Re: Restoring deleted rows
 
From:   McCall, Glenn David

  If I made delete from table with no journals and backup by SQL Assistant, is there a way to roll it back?..  


Assuming the request has been "committed" (99.99999999% chance that it has), you are in the following territory:

* restore from backup

* reload from source.


If you are lucky, someone might have set up some auditing on the table (I've done this in the past where certain tables are subject to stringent controls and auditing). In this case the delete and the rows deleted will have been recorded and you could theoretically get the deleted data restored from there. I suspect that you would be very, very, very lucky if this was the case.

Before running a delete, it is a good idea to replace the "Delete" keyword with "select count(*) from" or "select * from" in your query. That way you can get a feel for what data is going to be affected **before** it ends up on the one way street to the bit bucket.


Glenn Mc



     
  <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