Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 28 Feb 2005 @ 14:09:59 GMT


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


Subj:   Re: Backing up Structures (DDL)
 
From:   Crisafulli, Ronald

You might consider the following procedures:

1.In my environment I have the following set up:

          xxx             =   Corporate DB Allocation
          xxxPdata        =   contains all Prod Tables
          xxxPdataview    =   contains all Prod Views
          xxxPsecureview  =   contains all Prod Views that have limited access
          xxxPtmp         =   where all temporary tables are created
          xxxParch        =   contains all Tables being archived that week

          xxxQdata        =   contains all Prod Tables in a QA environment
          xxxQdataview    =   contains all Prod Views in a QA environment
          xxxQsecureview  =   contains all Prod Views that have limited access in a QA
          xxxQtmp         =   where all temporary tables are created in a QA environment
          xxxQarch        =   contains all Tables being archived that week in QA

          xxxTdata        =   contains all Prod Tables in a TEST environment
          xxxTdataview    =   contains all Prod Views in a TEST environment
          xxxTsecureview  =   contains all Prod Views that have limited access in a TEST
          xxxTtmp         =   where all temporary tables are created in a TEST evironment
          xxxTarch        =   contains all Tables being archived that week in TEST

On a daily basis I backup xxxPdata since it is the source of all DW data and is updated every night with Sales transactions from all the stores in the chain. On the weekend I backup all Databases. In this setup I can restore one or all DB's to Production, QA, or Test and get what I need.


Ron



     
  <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: 28 Jun 2020