• Ok so you are learning the practicality of a replicated and massive database between distant site. You have practiced the exercise and this is good. But if this happened again next month its my advice that you pickup the 80mile distant server (2 hours), use a local network (ie: crossover cable between the servers 2nd nics) and perform the replication in person at 100mbit or 1000mbit speed.

    If you end up having to do the driving... 1 it gets you out of the office so you can do some mental regrouping, 2 you will treat that 2nd db server like a fragile egg, 3 you will be encouraged to get the whole deal done with so you can get your lifeback after you return the machine to its proper site location.

    You know the technical aspects due to the experience but when you measure it next to the alternatives:  Time... Time... Time... (2.5 days to rep 2 tables and all the other tables... next time there will be that much more data)

    save yourself Chris

     

    Sean