Archives of the TeradataForum

Message Posted: Fri, 21 Sep 2012 @ 22:06:20 GMT

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

Here is my back up script. I don't delete the journal and I use unique checkpoint each day.

     LOGON  DBC/DBC,"PASSWORD";
     CHECKPOINT (PJ_INCREMENTAL.JOURNALTBL), WITH SAVE,
     NAMED CHKMON;
     ARCHIVE JOURNAL TABLE (PJ_INCREMENTAL.JOURNALTBL),
     RELEASE LOCK,
     FILE = INCBKP;
     LOGOFF;

I keep appending the backup to the same file INCBKP with different checkpoints for each day ( CHKMON for Monday , CHKTUE for Tuesday and so on)

Thanks

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