SQL Server Performance Forum – Threads Archive
Peer to peerHai Friends I Read about peer to peer replication.But after applying sp1 also I am not finding peer to peer option.When I am going to create publication I am seeing old three options sanpashot,merge,transactional.whether it is not released with 2005
Create a publication first using the New Publication Wizard.<br /><br />Enable the publication for peer-to-peer replication using the Publication Properties – <<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />ublication> dialog box.<br /><br /<a target="_blank" href=http://msdn2.microsoft.com/en-us/library/ms152536.aspx>http://msdn2.microsoft.com/en-us/library/ms152536.aspx</a><br /><br /><br />Mohammed U.
mohammed.I didn’t seen any option like that peer to peer in publisher dialog box.Any way Transactional replication have two flavours.1)Transactional replication 2)Transactional replication with updatable subscriptions in this second one is peer to peer replication or it is different
I think you are trying to configure peer-to-peer in different way. here is the way to do this
http://www.sql-server-performance.com/da_peer-to-peer_replication.asp also, you should have SQL Server 2005 Enterpise to enable peer -to -peer replication —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
What edition you are using?
As Dineshasanda mentioned it requires EE.
Thanks, Dinesh.Wonderful man from beautiful Island.I tested it.It sounds good.But still peer to peer replication is still not reliable technology
Suppose I have peer to peer databases.I connected to both through my application.I am accessing same record on that two servers.I am saving the record with in seconds latency.Do you know what is the output?
What I saved in first server it goes to second and same from second to first database.Ultimate result two different records in two databases,
in one databse name is ‘Ashoka’ and another database it’s ‘Ravan’.I done it only for two databases.If it is three or more means what will be the output.if it’s saving last saved record in all databases it’s ok.Here it’s purely a uncertain & unpredictable result if any situation comes like this.Anyway a I am wishing to you all a prosperous & peaceful NewYear Filson