Archives of the TeradataForum
Message Posted: Thu, 27 May 2010 @ 14:55:26 GMT
<-- Anonymously Posted: Tuesday, May 25, 2010 11:13 -->
We have aggregate tables with the history data of 10 years. To save the space, it has been decided to reduce the retention to 5 years. However, when the requirement for accesing the old data comes , we would have to restore the data that has been archived (immediately).
For this we have plannned the strategy as folows:
Moving the history data (i.e from main table to temp table) which would make it 'unusable' by the main table but usable as a (set of tables) in its own. This would be where the older data would be restored back to from tape.
We need to build a process which copies data from the temp tables to a tape. After the successful backup we need to build a process to restore data to the new tables from tape.
Can somebody please help & suggest like what should be the design followed for this.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|