Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 Where is Configure Peer-to-Peer Topology option?

Author  Topic 

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2007-03-22 : 12:47:51
Where is Configure Peer-to-Peer Topology option, in transactional replication?

I have created a publication using,
http://msdn2.microsoft.com/en-us/library/ms152536.aspx#

but not able to find Peer-to-Peer Topology option...

Can any one guide here

I have refreshed all nodes in ssms ;-)




------------------------
I think, therefore I am - Rene Descartes

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-03-23 : 00:33:36
To configure peer-to-peer transactional replication, we need to select Transactional publication.

After the publication is created, we need to change its properties. In the Publication Properties window (see below), set Allow peer-to-peer subscriptions to True. Please note that once we set this property to "true" we cannot revert to "false" until replication for the publication is dropped.

Read the following article...
http://www.sql-server-performance.com/da_peer-to-peer_replication.asp


MohammedU
Go to Top of Page
   

- Advertisement -