Archives of the TeradataForum

Message Posted: Tue, 09 Jul 2013 @ 16:58:56 GMT


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

Subj:		Re: Differential Backup

From:		Dave Wellman

Hi,

For something like this you could:

- Take a dictionary archive of the relevant databases each day, this will give you the structure and is relatively quick. Then use PJ's to recover the data.

- Restrict the user to only creating tables in certain databases (e.g. playpen, sandpit or whatever you want to call them) and take full archives of those db's every day.

Cheers,

Dave

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