In a MSCS SQL 2000 SP3 cluster environment I plan on implementing
transactional replication. Distributor and publisher are on the same server
(quad processor machine). I Intent to publish a relatively small db (@. 60
articles) to a subscriber in a remote SQL Server cluster and would like to
have updates made to subscribers also replicated back to publisher. I
understand bidirectional replication is not supported by the replication
wizard in enterprise manager. How can that be achieved?
For starters, this article may help:
http://support.microsoft.com/default...75&Product=sql
There's also an article on this subject in SQL Server Magazine
(www.sqlmag.com) by Bren Newman, ArticleID 42858.
"Cesar" wrote:
> In a MSCS SQL 2000 SP3 cluster environment I plan on implementing
> transactional replication. Distributor and publisher are on the same server
> (quad processor machine). I Intent to publish a relatively small db (@. 60
> articles) to a subscriber in a remote SQL Server cluster and would like to
> have updates made to subscribers also replicated back to publisher. I
> understand bidirectional replication is not supported by the replication
> wizard in enterprise manager. How can that be achieved?
>
>
Monday, March 12, 2012
How to configure bidirectional replication
Labels:
bidirectional,
cluster,
configure,
database,
distributor,
environment,
implementingtransactional,
microsoft,
mscs,
mysql,
oracle,
plan,
publisher,
quad,
replication,
server,
sp3,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment