Transactional replication (Stopped replication problem)

• Greg Czechowicz

  Grasshopper

  Points: 24

  More actions

  October 19, 2004 at 9:59 am

  #161664

  Last night I noticed that our replication stopped replicating. So I did a snapshot, then for some reason I ran the push agent right after that( dont think i was supposed to do that). Basically my question is, how do I get my transactional replication working again. It it as simple as doing a snapshot then waiting for the next hourly update?

   

  Thanks,

  Greg

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  October 20, 2004 at 7:49 am

  #527315

  Try to force the distribution agent to see if it is still working or if shows any error.

  You can do this by running the Job of the distribution agent in the publisher (for push subscriptions) or the subscriber (in the pull subscriptions).

  Also can run the agent by executing distrib.exe. (usually in c:\program files\microsoft sql server"\80\com). Check in BOL for parameters.

   

  If you find any errors after running the agent, post them here so we can help you.