Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 28 Jan 2005 @ 16:37:01 GMT

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

Subj:   Re: Maximum Limits of Users in Warehouse
From:   McBride, Michael

The reference David made was to only restore the DBC and not the actual restore of the userdbs. In order for a true re-creation of an entire instance of Teradata, you need to restore both the DBC AND all the databases (including users databases).

Note: I see a problem if you only restore the dbc and not the users in from the archive. You may have a problem with a create user statement, if the dbc thinks that user already exist. I have never tried to create a user after a restore of the DBC without a restore of the users databases as well.

This is even more critical when you perform cluster backups, because a dictionary backup has to be taken in addition to the dbc database tables, as a separate archive job because they are excluded from a cluster a backup.

Michael E. McBride
Teradata Certified Master
Teradata Database Administrator
Data Architect and Data Warehouse Practitioner
American Eagle Outfitters

  <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: 15 Jun 2023