All Forums UDA
Hillol 2 posts Joined 01/14
22 Jan 2014

Hi, What is the differnce between Restore script and copy script while restoring a job from TaraGui?
I have already taken backup of a job,but i am unable to create the proper script to restoe the backup.

Dixxie 58 posts Joined 12/10
23 Jan 2014

Hi Hillol,
The Restore will recreate the same object backuped.
The Copy will create a new object with the backuped object.

raju255007 2 posts Joined 01/14
28 Jan 2014

Teradata DBA Training

teradatauser2 236 posts Joined 04/12
07 Mar 2014

1. For restore, the table/object should already be present ( the definition ). While copying, the table will be dropped and created if already present and will be created as per backup defn, if not present.
2. Restore can be only in the same DB in from which it was created. While copying, a different DB can be specified.
3. Please check for the cross system copying ( google it )
Generally, we use copy script while using the taragui and not restore script.

You must sign in to leave a comment.