Merge Replication' s purpose is to synchoronize (especially mobile) clients
and the server. It's a client->server \ server<-client topology. It's not a
design for a DR solution indeed.

So if you are looking for a DR solution, you should think of Log Shipping or
Database Morriring. Replication is an expensive solution and the best one
would be Transactional Replication if you insist on using Replication for DR
purposes. Of course, you should consider the network and IO while deciding
which one is the best for you. Otherwise you may have lots of headaches. For
example, if your network bandwidth between the primary server and secondary
server is a public network and not enough to send and recieve the data then
it's going to stuck one day. Same for the IO. These are important stuff to
take into account.

First, determine your needs and then consider your available hardware and
then choose the solution for yourself. Of course you can buy new stuff for a
better solution, it depends on your budget.

--
Ekrem Önsoy




"Test" <test (AT) hotmail (DOT) com> wrote