 |
 |
Archives of the TeradataForum
Message Posted: Mon, 28 Feb 2005 @ 11:18:32 GMT
| Subj: | | Re: Backing up Structures (DDL) |
| |
| From: | | Ferry, Craig |
From what I understand, there is no way to backup just the structure(DDL) via netvault for individual restore. So if you have a single view
that needs to be restored, you must restore the entire database it resides in. Your two options are to either have all non-table structures in
their own database for easy restore or dump the ddl to a file on a regular basis. I have a shell script that I use to dump my non-table ddl to a
file each night.
Craig
_____
Craig Ferry
Sr Database Administrator
WESCO Distribution, Inc.
| |
