Re: Peer to peer replication on SQL 2000?

Mike,

It absolutely can not be done. You wind up with endlessly looping transactions.


unfortunately this kind of solution is the one I'd want to deliver, not having SQL 2005 ;(
What would you suggest me to do with SQL 2000? I have 3 servers, and want to let all of them be both publishers and subscribers, so that any modification done on any of the three servers replicates to the others.

I initially thought at merge replication, then I liked the suggestion about bi-directional replication... could I use merge replication and design a circular topology? Or should I use a mix - you tell you're using both transactional and merge repl. types - ?

Thanks for any help,
al.
.

Relevant Pages

  • Re: Need starting advice...
    ... Never ask a woman about to give birth if she wants more kids. ... to non domain servers as well as domain servers... ... done it many times) that it can take 200 lines of code to setup SQL ... Server Express to handle replication. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: A clustering question
    ... completely synchronize the SQL application with synchronous replication. ... This will virtually mirror the SQL application on the 2 servers. ... replicated data cluster which can perform the exact task that you ...
    (microsoft.public.windows.server.clustering)
  • RE: MERGE AND TRANSACTIONAL REPLICATION SUPPORT
    ... Thank you for your suggestions including the books that will soon become ... hundreds of book when using Oracle for replication. ... We expect to have 4 servers located on 4 geographical areas. ... That will be done by 3 other SQL programmers. ...
    (microsoft.public.sqlserver.replication)
  • Re: Branch Office Deployment
    ... The question you are really asking goes beyond AD and SQL ... distributed transactions and locking before going that route. ... We want the app to be available in the event the link ... What about replication? ...
    (microsoft.public.windows.server.active_directory)
  • Transactional Replication with Updating Subscribers and RPC
    ... I have a real sticky problem that I hope one of you bright SQL gods can help ... Problem is, my understanding is in order to use this replication, ... RPC traffic has to be allowed across the firewalls of the networks. ... Furthermore these transactions may be ...
    (microsoft.public.sqlserver.replication)