January 26, 2007 at 7:01 am
2005 -> 2005 Transactional Repl, Pull Subscription, Distributor is Publisher:
We've had this config working fine for a while. Last night we added a few tables to our publisher, then used sp_addarticle to add those articles to our existing publication (the same way we did to originally create the publication). Yesterday the publication had 29 articles, now has 34. So far so good.
But we can't get the data over to the subscriber. Re-init from subscriber doesn't work, it feels there is nothing to do. Manually start snapshot agent on publisher causes that do run, but when it's finished it reports "a snapshot of 29 articles was generated."
We used same sp_addarticle syntax to add the new articles as we did with the original articles. In SSMS the publication appears to be correct, has all 34 articles, and all the article properites look correct to me.
Anyone experience this before, or have an idea what might be wrong?
January 26, 2007 at 10:02 am
Resolved: needed to run sp_refreshsubscriptions after sp_addarticle, and before running snapshot agent.
Seems to me this info was much harder to come across than it should have been.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply