Post reply

Replication with mirroring

  • November 29, 2013 at 5:25 am

    #280517

    If I have A,B and C Database server,

    A to B Mirroring

    A to C replication

    when A is down then B is principle .In this case is there any function or change that c is replicated to B.

  • January 7, 2014 at 1:45 pm

    #1678224

    Yes - C can still be replicated to by B, so long as you have applied specific location information to the Distribution database about where the logs are for B to use, and so long as you have Trace Flag 1448 enabled...

    USE distribution

    GO

    -- For Snapshot Agent

    EXEC sp_add_agent_parameter

    @profile_id = 1,

    @parameter_name = N'-PublisherFailoverPartner',

    @parameter_value = N'Your Mirror Database Server Name goes here'

    -- For Log Reader Agent

    EXEC sp_add_agent_parameter

    @profile_id = 2,

    @parameter_name = N'-PublisherFailoverPartner',

    @parameter_value = N'Your Mirror Database Server Name goes here'

    -- For Distribution Agent

    EXEC sp_add_agent_parameter

    @profile_id = 3,

    @parameter_name = N'-PublisherFailoverPartner',

    @parameter_value = N'Your Mirror Database Server Name goes here'

    ---- For Merge Agent

    --EXEC sp_add_agent_parameter

    -- @profile_id = 4,

    -- @parameter_name = N'-PublisherFailoverPartner',

    -- @parameter_value = N'Your Mirror Database Server Name goes here'

    -- Queue Reader Agent

    EXEC sp_add_agent_parameter

    @profile_id = 9,

    @parameter_name = N'-PublisherFailoverPartner',

    @parameter_value = N'Your Mirror Database Server Name goes here'

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply