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

Arsen Vladimirskiy
Nov 20, 2017 · 2 min read

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.

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.

DSC command line examples

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

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.

Arsen Vladimirskiy

Written by

Azure Cloud Architect & Software Engineer at Microsoft, Commercial Software Engineering (CSE) Team