Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 09 Jan 2004 @ 17:21:07 GMT


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


Subj:   Re: Need list of tables being backed up with NetVault
 
From:   Dye Lisa

Phil,

You could use the DBC.Events view - use CreateDate, EventNum and EventType(DUMP).

If an ARCHIVE script specifies more than one database, ARCMAIN archives the databases and all their tables and stored procedures in alphabetical order.

If an ARCHIVE script specifies multiple tables, ARCMAIN archives the tables in alphabetical order of table within the database.

This would give you a starting list of objects for an event--but as you indicated, you'd still have to cross-reference it to your Netvault job info....(yek!)


Thanks,

Lisa



     
  <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