Updatable subscriptions questions

• Dominic Wallace

  Newbie

  Points: 1

  More actions

  March 16, 2007 at 4:27 am

  #123243

  We are replicating our production realtime transaction switch over a 2 meg link to our DR site using updatable subscriptions.  We do around 20 tps.

  When we failover the server over there will push the information back to the distributor on the primary site and back to the publisher (this I understand) but my question is will the change be republished back to subcriber that originated the update??

  I am trying to work out if I am better off reversing replication - we normally stay over at our DR site for about 1 week and I am thinking of the strain on the WAN.

  Cheers

  dom

• MohammedU

  SSCoach

  Points: 19644

  More actions

  March 17, 2007 at 6:25 pm

  #695590

  Check for Peer to peer replication...

  Peer-to-Peer Transactional Replication in SQL Server 2005

  http://www.sql-server-performance.com/da_peer-to-peer_replication.asp

  http://www.microsoft.com/technet/technetmag/issues/2006/07/InsideMSFT/

   

  MohammedU
  Microsoft SQL Server MVP