var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: replication problem
MS SQL server 2000 sp4
Added one article to replication a couple of weeks ago and just realized that it's no replicating.
when I do a
sp_helpsubscription @publication = 'MY publication'
I see the article.. but it's not replicating. did a new snapshot and that didn't work.
I reinitialized and then kicked off my REPL agent to run .. still not working
doing transactional replication. log reader is running all the time and the distribution agent runs once evey 15 mins.. can anyone help?????
Does the Snapshot agent give any error?
no errors from snapshot agent
And the article is associated with the correct subscriber? Was the table created at the subscriber? Is it empty, or does it just have stale data?
it exists on the subscriber and it is not empty - it has stale data
can someone tell me what the correct sequence of commands to drop this article from the subscription and readd it?