SQL Replication reg.

• jagcbe

  Valued Member

  Points: 62

  More actions

  March 24, 2018 at 1:39 am

  #344118

  We have 4 SQL server 2008 version we have transaction replication between A pair of DB / Server and
  Pair of SQL mirror between 2 Db Servers. Kindly the see Present scenario of diagram
  
  We have Done Transnational Replication between DB XXX to DB YYY and DB YYY to DB XXX and Same time
  DB YYY is Sql mirrored on Server D with Witness server C for auto Fail over purpose.
  During Server B Failure Server D (DB YYY mirror) become Principle.
  During this condition how to we achieve automatically or Simple manual work
  Transnational Replication between Server A DB XXX to Server D YYY DB
  and Server D YYY Db to Server A DB XXX (Server D become principle) done.
  kindly help us to achieve this scenario.

  Thanks in Advance
  Jagadeesh