locked
Subscriber - Failover Mirroring RRS feed

  • Question

  • Hi,

    I am in the progress implementing database mirroring for our SQL server to achieve HA.

    There are some of our SQL are replication subscriber and as per googling can't find the steps to implement mirroring on subscriber sql server. 

    Please help to advise if anyone have implement subscriber server failover mirroring.

    Will appreciate your reply.

    Thursday, September 1, 2016 10:48 AM

All replies

  • Check this link, you have a document with the subscriber database mirroring information:

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


    Please mark the answer as solved and vote as helpful to help others

    Thursday, September 1, 2016 10:59 AM
  • See below -

    Ref-http://sqlmag.com/blog/which-replication-databases-can-i-mirror

    The subscription database can be mirrored on SQL Server 2005, but after a mirroring failover a new subscription has to be created and fully reinitialized from a backup or a snapshot, which usually isn’t palatable.

    In SQL Server 2008, a new subscription must still be created after a mirroring failover of a subscription database but there’s a new initialization method, initialize-by-LSN, which makes this configuration much more attractive. The initialize-by-LSN method lets the subscription database be initialized by using unapplied changes from the distribution database, instead of having to completely reinitialize the database.

    Also 

    Database Mirroring and Replication (SQL Server)
    https://msdn.microsoft.com/en-IN/library/ms151799.aspx?f=255&MSPPError=-2147217396

    https://www.pythian.com/blog/how-to-configure-transactional-replication-mirroring-failover/



    Regards, S_NO "_"

    • Proposed as answer by Teige Gao Friday, September 23, 2016 2:58 AM
    Friday, September 2, 2016 4:18 AM
  • Yes but pythian link you provided for Publisher mirroring failover and not Subscriber failover.

    The msdn i got read before but i prefer whether there graphic explanation on initialize by LSN method?

    Apreciate if you provide if you got experienced on this before.

    Saturday, September 3, 2016 4:57 PM