Archives of the TeradataForum

Message Posted: Mon, 02 Apr 2012 @ 18:50:34 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

TD 13 on Windows

Dear DBAs,

When you receive a request from developers to drop and recreate tables for some reasons do you create backup tables with data first before dropping and recreate them?

If you do, do you make backup tables both in production and development or just production?

In DB2 we make image copies before and after dropping and recreating tables for safeguard.

I'd like to know if we do the same way in TD. If we don't what are other ways to protect tables? I remember someone mentioned 'Fallback'.

If we create tables with Fallback don't we have to create backup tables before dropping?

Thank you,

James Park

	<Prev	Next>		<<First	<Prev	Next>	Last>>