SQL Server Performance

Peer to peer

Discussion in 'SQL Server 2005 Replication' started by filson, Dec 24, 2006.

  1. filson New Member

    Hai 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
  2. MohammedU New Member

    Create a publication first using the New Publication Wizard.<br /><br />Enable the publication for peer-to-peer replication using the Publication Properties - &lt<img src='/community/emoticons/emotion-4.gif' alt=';P' />ublication&gt; 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.
  3. filson New Member

    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
  4. dineshasanka Moderator

  5. MohammedU New Member

    What edition you are using?
    As Dineshasanda mentioned it requires EE.

    Mohammed U.
  6. filson New Member


    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


Share This Page