Failover with Replication

• Luke79

  SSCrazy

  Points: 2571

  More actions

  January 18, 2007 at 11:02 am

  #153390

  I was wondering if anyone has run accross a setup where a publisher is setup on the principal database.  What happens if the prinicipal server goes down.  How can we ensure that publication is not interrupted and switches over to the mirror as well?  And finally if you're running a setup like this did you run into any issues/problems?

   

  Thanks!

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 18, 2007 at 3:42 pm

  #684134

  SQL Server 2005 Books Online 

  Replication and Database Mirroring 

  http://msdn2.microsoft.com/en-us/library/ms151799.aspx#

  FIX: The replication on the server does not work any longer when you manually fail over databases in SQL Server 2005

  http://support.microsoft.com/default.aspx/kb/912471?wa=wsignin1.0

   

  MohammedU
  Microsoft SQL Server MVP