Teradata Backup to Azure Blob Storage using Data Stream Controller (DSC)

In this video, we look at backing up and restoring Teradata database tables to Azure Blob Storage using Teradata Data Stream Controller and Viewpoint VMs deployed from Azure Marketplace.

Video Walkthrough

Tip: Play the video full screen.

Table of Contents

00:00 — Introduction
01:19 — Deploy Teradata Database Solution Template
03:13 — View Deployment Status
04:10 — Deployment Finished
04:51 — Login to Viewpoint
06:33 — Create databases
08:38 — SSH into Viewpoint
10:59 — Review DSC User Guide
12:20 — BAR Setup
14:22 — DSMAIN Restart
16:52 — Adding Azure Blob Storage
21:04 — SSH into DSC VM
22:24 — Add BAR Operations to Viewpoint Dashboard
23:31 — Create Backup Job
24:35 — Run Backup Job
26:04 — Insert more data into table
28:05 — Delete database from table and restore
30:06 — Restore to another database
32:32 — Confirm restore worked

Teradata Data Stream Controller

Create test databases for backup and restore

Use Viewpoint SQL Scratchpad or BTEQ to create the test databases and a small test table.

create database db1 as perm=5e9 spool=1e9 temporary=1e9;

create table t1 (id int, name varchar(255));
insert into db1.t1 (id, name) values (1, 'name1');
insert into db1.t1 (id, name) values (2, 'name2');
insert into db1.t1 (id, name) values (3, 'name3');

select * from db1.t1;

create database db2 as perm=5e9 spool=1e9 temporary=1e9;

DSMAIN restart

See page 43 of the Data Stream Controller DSA User Guide for more details and execute these commands on Teradata Database node 0 after adding Teradata system to DSC via Viewpoint.

cnsterm 6
start bardsmain -s
start bardsmain
start bardsmain -j

DSC command line examples

These commands can be used on the dsc-vm0 to query for job status and other settings.

dsc list_components -t system
dsc list_components -t azure_app
dsc list_components -t media_server
dsc job_status_log -n backup1

Thank you!

Please leave feedback and questions below or on Twitter https://twitter.com/ArsenVlad

Originally published at blogs.msdn.microsoft.com on November 20, 2017.

Principal Engineer / Architect, FastTrack for Azure at Microsoft

Principal Engineer / Architect, FastTrack for Azure at Microsoft