Hi,
Ans for Updating Question,
1. I'm also faced this issue. But i tried lot. I can't get the original data which is having before the Updation. If you have backup of the database means you just simply restore and get those data's from there. Other Wise you won't. And One More thing Here after, without begin transactions and commit/ rollback you never execute the Update query.
Ans for Copying the Data from One Server to Another Server,
2. You can the Linked server. If you add the Server into another Server it very easy to copying the data.
Use the Following statement:
Sp_AddlinkedServer "ServerName"
Regards,
Karunanidhi.K