In my opinion its just a matter of understanding ....
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.
You would make a Copy data in when the table does not currently exist, when the table had been dropped and recreated since the time the backup was taken and if you want to make a copy of the table in a different database, other than the one in which it exists.
Might be little bit confusing but it is based on your need.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 7/28/14, 8:19 AM|
|Seen: 2898 times|
|Last updated: 5/19/15, 4:18 AM|