Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 22 Oct 2004 @ 18:56:26 GMT


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


Subj:   Backups
 
From:   Ferry, Craig

We had a problem recently with our backup software on teradata where we needed to restore a single view. I could not find a way to do it, so I opened an incident. I was told in the incident that the only way to do this was to restore the entire database either over the existing database OR to a new location (by renaming it). Neither of those was really an option for us because we didn't want to overwrite newer data and we don't have the space to recreate another copy of the database.

We have been able to rebuild the view, but I was wondering how other people make regular backups of views, procedures and macros (they fall into the same category) so they can restore them individually.


Thanks

Craig

Craig Ferry
Database and Unix Administrator
WESCO Distribution, Inc.



     
  <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