TaraGui

UDA
Fan

TaraGui

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.

3 REPLIES
Enthusiast

Re: TaraGui

Hi Hillol,

The Restore will recreate the same object backuped.

The Copy will create a new object with the backuped object.

Regards.

Re: TaraGui

Teradata DBA Training

Junior Supporter

Re: TaraGui

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.