Re: Peer to peer replication on SQL 2000?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com


"AL" <albeNOSPAM@xxxxxxxxxxxxxx> wrote in message
news:uAJszyREGHA.376@xxxxxxxxxxxxxxxxxxxxxxx
> Hello,
> reading about peer-to-peer transactional replication in SQL 2005
> (http://msdn2.microsoft.com/ms152536.aspx), I would like to do the same
> thing with 3 SQL 2000 servers. Of course peer-to-peer replication is not
> available, but can anybody suggest a way to simulate this kind of
> replication with SQL 2000?
>
> thanks,
> al.


.

Relevant Pages

  • Re: Replicating very large articles but need to avoid locks from s
    ... thank you for the response and tip regarding snapshot processing. ... familiar yet with all of SQL 2005's offerings. ... all averse to replication and used SQL 2000 Transactional replication ... The last issue came from the Distributor clean up job. ...
    (microsoft.public.sqlserver.replication)
  • Re: Replicating very large articles but need to avoid locks from s
    ... snapshot processing will be inadequate to scale (it is not a pretty sight ... familiar yet with all of SQL 2005's offerings. ... all averse to replication and used SQL 2000 Transactional replication ... The last issue came from the Distributor clean up job. ...
    (microsoft.public.sqlserver.replication)
  • Re: clustering enquires
    ... Another 3rd party option is LifeKeeper Protection Suite for SQL Server from ... The benefits of host based replication from LifeKeeper is that you don't ... In addition, LifeKeeper can support Active/Active clustering, Cascading ...
    (microsoft.public.sqlserver.clustering)
  • Re: Change distribution server
    ... This is more of a maintenance question regarding replication. ... With all the SQL Agent jobs and replication pieces, ... Remember my scenario has the remote distributor on SQL2000 if that matters. ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Offline scenario with low bandwith
    ... SQL replication transmits only changes. ... > with datasets or diffgrams sent from the mobile users. ... > GPRS to the central server. ...
    (microsoft.public.sqlserver.ce)