Replication Monitor show completed, and no replication ( data on subscriber side). RRS feed

  • Question

  • Hi all,

    I have a Transactional Replication, the replication Monitor show status = Completed. 

    But on subscriber side there is no data in selected articles. 

    What is wrong with the status, sometime it was Running but now it shows Completed.


    Muhammad Nadeem

    Friday, May 19, 2017 7:26 AM

All replies

  • We will need a bit mor information. As I understand distribution agent went into completed state? Did you check SQL Job Activity Monitor if the distribution agent is stopped/completed? Did you try to start it again and after that still no data on subscriber?

    The Completed status, that sometimes happen and you just need to kick off the agent again. You can also modify distribution agent job that on success (step 2) go to Step 1 etc.

    Friday, May 19, 2017 10:48 AM
  • Does is show now data or no recent data?

    What is the subscriber status? Does it say something like

    The process is running and is waiting on a response from the server

    The subscription to this publication is not active yet. No user action is required

    The concurrent snapshot for publication XXX is not available because it has not been fully generated or the Log Reader Agent is not running to activate

    The initial snapshot for publication XXX is not yet available.

    Friday, May 19, 2017 11:02 AM