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

Teradata® DSA User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
BAR
Data Stream Architecture
Release Number
17.20
Published
November 2022
Language
English (United States)
Last Update
2023-11-30
dita:mapPath
bis1632417576364.ditamap
dita:ditavalPath
vwp1576617377804.ditaval
dita:id
cyv1467242268519
Product Category
Software
Teradata Tools and Utilities

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