Scheduling and incremental backup in DSA

Backup Archive and Restore (BAR)
All things BAR
Teradata Employee

Re: Scheduling and incremental backup in DSA

For the first incremental backup after a full backup, there is no difference between delta and cumulative - both would have all changed blocks since the full backup. If you did a second incremental backup mid-week then delta would only have changes since the first incremental while cumulative would have all changes since full backup.

 

Yes, restore will delete existing data, restore from the most recent full backup, then from the most recent cumulative, then apply any deltas taken since the last cumulative (or since the full backup, if no intervening cumulative).

Enthusiast

Re: Scheduling and incremental backup in DSA

Tested to restore into same system. Seems in that case also it is again doing full backup and then incremental. Please let me know if I am missing anything?
Teradata Employee

Re: Scheduling and incremental backup in DSA

Perhaps you misinterpreted Todd's response.

 

Currently: restore always starts by restoring a full backup.

 

In the future: you will be able to create a copy of the data using a full backup initially, then later apply incremental backups from the original to that copy (without starting over from the full backup). A typical use case for this functionality would be to bring a read-only / DR system "current enough" to meet the Recovery Point Objective.

Enthusiast

Re: Scheduling and incremental backup in DSA

Regarding your comments: In a future update of TD 16.20, Teradata will allow incremental backups to be restored to a system on an ongoing basis. Today however, it is onlly allowed to restore the full backup and all relevant incrementals as a single operation.

 

Question: Is it on Teradata database version of 16.20 or DSA version of 16.20?

Enthusiast

Re: Scheduling and incremental backup in DSA

Can someone please confirm on this.

 In a future update of TD 16.20, Teradata will allow incremental backups to be restored to a system on an ongoing basis. Today however, it is onlly allowed to restore the full backup and all relevant incrementals as a single operation.

 

Question: Is it on Teradata database version of 16.20 or DSA version of 16.20?