Archives of the TeradataForum

Message Posted: Tue, 10 Feb 2004 @ 14:30:05 GMT

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

RESTORE only works on a different system if you have restored database DBC (e.g. in a disaster recovery or system migration scenario) so the internal object IDs match. Otherwise you must use COPY. And you must restore or copy the dictionary entries separately, before the first set of cluster data.

Using CLUSTER dump trades off a shorter "backup window" against a more complicated recovery. In normal operations, one tends to ARCHIVE or DUMP many times and seldom, if ever, RESTORE or COPY - so cluster dump is a clear winner for large tables or databases if you have sufficient resources (e.g. multiple backup devices).

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