Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Backing up table before dropping

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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020