Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 19 Mar 2008 @ 13:51:06 GMT

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

Subj:   Re: Conflicts with Teradata Backups
From:   Koneru, Rajesh

Another option you might want to consider is Journals for mission critical loads. This allows you to check point and save the journal in place of the actual database table while it is being loaded to. Also archive strategies can be built for pulling the incremental change records into a backup database and archiving that in place of the original table. Since the amount of change records would not be as huge, the archive on the database would also take up less time.

Both the above strategies do require that you have atleast one stop gap where the complete database is archived (probably on a holiday) so that the incremental changes or the journals can be applied over the same.

Thanks & Regards,

Contractor - TCS

  <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: 23 Jun 2019