Example Backup Strategy | Teradata DSA - 17.20 - Example Backup Strategy - BAR - Data Stream Architecture

Teradata® DSA User Guide

Product
BAR
Data Stream Architecture
Release Number
17.20
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-3150-101K
Language
English (United States)

Consider a site that performs a full backup every Sunday, a cumulative backup every Wednesday, and delta backups on the other days:

The table shows which save sets are restored when you select a given restore date.

Save Set Day Type Restore These
1 Sunday Full

All data for all tables.

1
2 Monday Delta

Data that changed today.

2, 1
3 Tuesday Delta

Data that changed today.

3, 2, 1
4 Wednesday Cumulative

All changes since the full backup.

4, 1
5 Thursday Delta

Data that changed today.

5, 4, 1
6 Friday Delta

Data that changed today.

6, 5, 4, 1
7 Saturday Delta

Data that changed today.

7, 6, 5, 4, 1