Archives of the TeradataForum

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

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

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>>