Re: Data backup

If the table you are to restore currently exists at the same location, (note that it has not been dropped and recreated since the time the backup was taken) you would make a restore job.

Copy Job:

You would make a Copy Job in one of the following situations:

The table does not currently exist in the current location

The table had been dropped and recreated since the time the backup was taken

If you want to make a copy of the table in a different database, other than the one in which it exists

For point 2 in Copy Job, even though the table exists with the same name, the Restore Job will fail and Copy Job would have to be made. This is because, for Restore Job to work the table header ID of existing table and table to restore should be the same. If the table is recreated, the table header ID is different.