Archives of the TeradataForum
Message Posted: Tue, 09 Jul 2013 @ 15:05:00 GMT
| Subj: || || Re: Differential Backup |
| From: || || Bakthavachalam, Roopalini |
Thanks for the detailed explanation Dave! So , when PJs cannot track changes to table structure, isn't that a big risk to use that option. We
take full backups every Saturday and journal backup Sun - Fri. Now, suppose the user creates a new table on the following Monday loads data till
Wednesday and accidently drops the table on Thursday and wants me to restore it, then I would not be able to restore that table at all, because
the structure of the table doesn't get backed up using PJ backup. Can you please suggest some ways to avoid this scenario?