Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 12 Jan 2007 @ 17:09:46 GMT


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


Subj:   Re: DBC Tables Backup.
 
From:   Bergman, Ysbrand

Hi ,

Backing up DBC has always been different from the rest of the system since we are talking about the system tables.

This means that:

- You can NOT specify a single table in DBC for backup nor restore

- You can only backup the entire DBC database

- Only ALL amp backups are supported

- Only a subset of tables is being processed. These are the tables that are make up the "system area" of your database

- If you want to save other specific tables, like accesslogs, you will need to copy them to a user database and save them subsequently.


If you want to know a bit more, like which tables are actually being processed, you can have a look in the "Teradata Archive/Recovery Utility Reference" manual. Chapter 2 "Archive/Recovery operations" has a section on DBC. This manual can be downloaded from the main NCR site.


Regards

Ysbrand

Ysbrand Bergman
BAR SME
EMEA RTS
Teradata - a division of NCR



     
  <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