Post reply

Replication-Subscriber Down Scenario

  • July 24, 2015 at 5:11 am

    #306021

    In Transactional Replication, consider a scenario where subscriber goes down for couple of days. In this case will there be any impact on publisher? I look forward to your valuable inputs

  • August 5, 2015 at 1:34 pm

    #1817696

    The impact will be on the distributor, and how long you have set the history for.

    The publishing database performs some data manipulation. These are sent to the distributor and held if the distributor can't talk to the subscriber(s).

    The distributor database could grow significantly depending upon the amount of data and how long it is being held.

    Steve Jimmo
    Sr DBA
    “If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan

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

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