Hi Guys
I am running SQL2000 I have set up Transactional Replication with a push
subscription.
My 2 servers are not in the same domain but can see eachother.
Server 1 is Distributor as well as publisher. All insert, delete & updates
made on this side replicates fine to server 2, however any inserts, delete or
update made on server 2 does NOT replicate back to server 1.
I do not get any errors everything seems fine except for the lack of
replication.
Any ideas?
Thanks.
Regards
Jonas
Jonas,
Transactional replication is one way by default (Publisher -> Subscriber).
To get it bidirectional, you need to set up immediate updating subscriptions
or queued updating subscribers.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Monday, March 12, 2012
Replication only working 1 way
Labels:
database,
domain,
guysi,
microsoft,
mysql,
oracle,
pushsubscription,
replication,
running,
server,
servers,
sql,
sql2000,
transactional,
working
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment