December 27, 2013 at 7:45 am
What exactly happens at the backend when we click on the start synchronization option ?
December 30, 2013 at 3:07 am
That's a pretty vague statement. Have you read the Microsoft documentation? Is this snapshot/merge/transactional replication?
There are many customisable options, such as initialise from backup, which can effect the way things happen.
The fundamental order of things once a subscription is added to a transactional publication go like this:
Logreader agent starts and begins collecting commands and entering them into the distribution db
Snapshot agent generates schema scripts and BCP's data to a unc folder
Distribution agent picks up the snapshot scripts and applies to the subscriber
Distribution agent keeps checking the distribution db for commands and applying them to subscriber
Snapshot is much simpler and only has a scheduled snapshot generation and application.
Merge introduces the merge agent which adds an additional complication.
December 31, 2013 at 10:45 am
Jimbo,
Thanks for the info. I am talking about transactional replication. Recently I noticed one of our subscription in inactive state. So I just right clicked on that subscription in replication monitor and clicked on the start synchronization. Does synchronization means all the steps you quoted or it just runs any particular job?
January 2, 2014 at 8:28 am
muthyala_51 (12/31/2013)
Jimbo,Thanks for the info. I am talking about transactional replication. Recently I noticed one of our subscription in inactive state. So I just right clicked on that subscription in replication monitor and clicked on the start synchronization. Does synchronization means all the steps you quoted or it just runs any particular job?
It sounds like the distribution agent was not running. Just this step.
MysteryJimbo (12/30/2013)
Distribution agent keeps checking the distribution db for commands and applying them to subscriber
Initialise or Reinitialise subscription would start from the top of my list.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply