Home Forums SQL Server 2008 SQL Server 2008 High Availability How to configure replication subscription from secondary server, after failover from primary server? RE: How to configure replication subscription from secondary server, after failover from primary server?

  • September 15, 2017 at 3:06 am

    #1959552

    Have you set the publisher failover partner and all the other settings to make replication work with mirroring?

    The Replication&DBM doc is a great read for this sort of setup

    https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-and-replication-sql-server

    http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/ReplicationAndDBM.docx