We have a SQL Server located in India; We need to move all the DB's on that server to a server residing locally for various legal reasons. The Server in India is a 2008 running 24 databases. 3 of these DB's are over 100GB and all 3 of them are being replicated from a third server in India. I am looking for high-level steps I will need to perform this so as to make sure I don't miss anything. Please advise, especially on problems I can expect to run into.
I did something similar when I was working for HP few years ago. I moved the backup file(s) over the network using robocopy from a server in China to one in USA. If I recall well, robocopy has a retry flag or command so it also helps during the process.
The whole process took almost a week though and I split the backup on several files. Using a single backup file won't work over a WAN.
Also, the speed and reliability of the WAN link is key. Otherwise, it may be better using old fashion methods like sending a backup tape via FedEx or similar services.