Ok so I've got 3 servers in this example
Server_A, Server_B, Server_C
I want to move data over the network from Server_A to Server_B by executing a batch script on Server_C, it would be something like this.
robocopy "\\Server_A\Share\" "\\Server_B\Share\"
1.) How is the data actually written to Server_B, does it get copied from Server_A to Server_C in a temp folder or memory then written to Server_B? Or does Server_C somehow actually tell Server_A to copy the file to Server_B directly.
My thoughts would be the data has to be read to a temp folder or memory on Server_C before it can then be written to Server_B which would mean that you effectively double the amount of data traveling over the network by using Server_C to manage the transfer it becomes an additional hop?
2.) Is it faster to run this data copy on server_A vs running on Server_B assuming all aspects of both servers are the same? Ie: When you copy from one server to another, does managing the copy on the source vs destination server have any real world impact?
I would guess running the copy from the source server is faster because it has the fastest access to the file allocating tables being they are stored locally, vs querying a remote server.
Thanks in advance for any input you can provide.