Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Fri, 28 Jan 2005 @ 15:32:21 GMT


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


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

I do agree Mr. Wellman's point to exclude the users (NONEMPTY DB) from the daily backup, with one caveat. You should backup them up at least once in a while in order to account for Disaster Recovery. This would be in the extreme case of a complete restore of the DBC and all you databases.

Alternatively, you could keep a script with all the necessary command to re-create them, but you will have to allow for the time to add them all back if not done as part of the DB restore process.


Regards,

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