• WhiteLotus (11/20/2016)


    Hi Alex

    Many thanks for the valuable feedback , It believe it will be very useful

    I will use witness server to act as DISTRIBUTOR then

    Questions :

    1.Should it install with the same SQL server edition like principal and mirror ? I assume we don’t need to ?

    2.My principal has been set up to act as its own distributor , How do I change it so I can use remote distributor ?

    Thank you ?

    Follow these steps:

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

    Alex S