November 6, 2015 at 2:41 am
As per attachmet, i have been created replications but in local subscription it is not populated any thing at the same time, Subscription database has been created but tables is not populated as per publication table.
November 6, 2015 at 4:10 am
Have you initialized the replication and generated the snapshot?
Snapshot replication runs on a schedule.
what schedule have you set?
What is the state of replication you look in replication monitor?
What do the logs say for the replication jobs?
November 7, 2015 at 2:50 pm
Right-click "local publications" and choose "Launch Replication Monitor".
Why was "Distributed Transaction Controller" circled?
The "distribution agent" that is mentioned in https://msdn.microsoft.com/en-us/library/ms151832.aspx does not mean DTC. Snapshot replication's "distribution agent" instead refers to an executable named distrib.exe (also documented in SQL Server books online), which is typically invoked by running a (scheduled, for snapshot repl) SQL Server agent job.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply