Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 02 Apr 2012 @ 18:50:34 GMT


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


Subj:   Backing up table before dropping
 
From:   JAMES PARK

TD 13 on Windows

Dear DBAs,

When you receive a request from developers to drop and recreate tables for some reasons do you create backup tables with data first before dropping and recreate them?

If you do, do you make backup tables both in production and development or just production?

In DB2 we make image copies before and after dropping and recreating tables for safeguard.

I'd like to know if we do the same way in TD. If we don't what are other ways to protect tables? I remember someone mentioned 'Fallback'.

If we create tables with Fallback don't we have to create backup tables before dropping?


Thank you,

James Park



     
  <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: 27 Dec 2016