Archives of the TeradataForum

Message Posted: Tue, 02 Jul 2002 @ 11:32:11 GMT

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

Karen,

I agree with the other comments that you've received on this one.

Benefits:

-- much faster backup and restore

Downsides:

-- operationally more complex: to restore from a cluster backup because you have to remember to restore the dictionary information first and then restore the data. I think that if you know that Teradata's internal 'version' for the table hasn't changed then you can probably just restore the data. Conversely an all-amp backup will hold the dictionary information on the backup file for you.

-- potentially more concurrent tape units required as (presumably) you'd only take this approach because you want the speed,

-- (I think) to restore even a single row table you have to restore all clusters

I tend to use the following general approach:

(1) start with all-amp backups for everything. Break the backup processing into manageable chunks so that individual jobs don't take too long, single backup files aren't too large

(2) only use cluster dumps when a single table all-amp backup takes too long (whatever your definition of too long is)

Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)

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