Hello Group,
I have 2 servers in my office. One in US and one in
India. Both Servers have same database. I want the 2
Servers to be in Synch. Insert/Update/Delete happen in
both servers. Can anyone suggest me the method to
approach to accomplish this setup. I am trying 2 way
transactional replication. I just heard that 2 way log
shipping is also possible.
Help me to accomplish this task
Thanks in advance

If by 2 way transactional replication you mean immediate
updating subscribers, this will work but you MUST have a
dedicated link that is always up, or else you will have
transactions hang for about 20 s, and then roll back with
as server access denied message. You can manually roll
over to queued updating.

Also updates will be translated into singletons for both
immeadiate updating and queued.

If you mean bi-directional replication using transactional
this does work.

Log shipping also will work, but when you apply the logs
on your standby server your users will have to go offline
and your database will be read only.

[quoted text, click to view]