I have to move 10 databases from a colo facility in Virginia to one in Nashville, TN. The databases range from 20 MB to around 8 GB. I'll be able to compress the backups around 60 - 80%. The problem is that the network bandwidth between the two colo's is pretty bad. We are trying to get additional bandwidth but if that fails, I need advice on the best way to do this. I just copied a 7.5 GB BAK file and it took 1:37 (HH:MM). This won't do since we have 10 to copy.
So -- I've been looking into using Log shipping for this. At some point prior to the cutover, I could set up log shipping on the source server and have it create and populate the destination server. We could leave log shipping running until the cutover and make the new, destination server the primary server and break log shipping. The original server in Virginia is going away.
During the actual cutover, our web application will be down. So we need to do this as fast as possible.
Does anyone have any suggestions? Is this a decent plan? Other ideas?