Post reply

Peer-to peer replication queries

  • December 20, 2014 at 10:50 am

    #293242

    I would like to know when configuring Peer-to-peer replication

    from SSMS in sql 2012 ent edition,why u have to configure transaction replication first and then do peer-to peer from ssms?????

  • December 26, 2014 at 12:14 am

    #1766438

    Peer-to-Peer replication builds on the foundation of transactional replication, and can be viewed as a multiple-node transactional replication with each node published to other nodes, and at the same time, subscribed to other nodes.

    See:

    http://blogs.technet.com/b/patricg/archive/2009/04/17/peer-to-peer-replication-in-sql-server-2008-configure-a-two-node-topology.aspx

  • December 26, 2014 at 12:21 am

    #1766439

    Hi,

    If you look closely you will see Peer to Peer replication is a twisted flavor of Transactional replication where in every node is a publisher and every node is subscriber.

    In other words you can see Peer to Peer replication as multiple instances of Transactional replication combined into one setup.

    Still it is transactional replication nothing more.

    Hope it Helps..!!

    Regards,
    Shafat Husain
    🙂
    And Your Lord Never Forgets...!! (64:19 -- Quran)

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply