what is the difference between
i. Data Restore
ii. Data Copy
-- During failover or maintainence we will take backup of existing data . In thet case will the above methods are useful ?
Can you please provide info.. on it.
-- restore the object must already exist, i.e: restore the sales_detail table to the sales database because a record was dropped.
-- copy the object does not need to exist. example: copy the sales_detail table to the sandbox database for testing or copy it to the sales database if the table was dropped
Below is the difference between the two:
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.
You would make a Copy Job in one of the following situations:
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.