SQL Replication amd Mirror Issue

• jagcbe

  SSC Journeyman

  Points: 92

  More actions

  November 9, 2017 at 2:35 am

  #324414

  Hi,

  We  have 3 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 Present scenario of diagram

  

  We have  Done Transnational Replication between DB XXX to DB YYY. and Same time
  DB YYY is Sql mirrored on Server C, for Fail over purpose during Server B Failure.
  During Server B Failure Server C (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 C YYY DB (become principle) done.
  kindly help us to achieve this scenario.

  Thanks in Advance
  Jagadeesh

• John Mitchell-245523

  SSC Guru

  Points: 148809

  More actions

  November 9, 2017 at 2:40 am

  #1967319

  Jagadeesh

  Does this help?

  John