Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Adding new articles to transactional replication
0 views
Skip to first unread message
Ben Thul
Nov 16, 2009, 3:12:15 PM11/16/09
to
In trying to add 3 new articles to an existing publication, I'm
encountering a small problem. Namely, after the snapshot is generated
for these articles, the distribution agent doesn't seem to pick it
up. As such, the new articles don't show up at the subscriber. As
far as I can tell, the new articles have all the same options as
existing ones.
encountering a small problem. Namely, after the snapshot is generated
for these articles, the distribution agent doesn't seem to pick it
up. As such, the new articles don't show up at the subscriber. As
far as I can tell, the new articles have all the same options as
existing ones.
One other thing that I found odd. In the course of trying to
troubleshoot, I tried dropping the articles. I dropped the
subscriptions, but when I go to call sp_droparticle, it says that
there are still subscribers. The syssubscribers table doesn't show
any subscribers to these articles.
Does anyone have any ideas? Thanks in advance.
Hilary Cotter
Nov 17, 2009, 10:43:42 AM11/17/09
to
These could be virtual subscriptions which you are seeing.
Did you do a sp_refreshsubscriptions to update your publication for these
new articles, and did you add them to the subscribers?
"Ben Thul" <thu...@gmail.com> wrote in message
news:192f2f1f-b104-4b9b...@v30g2000yqm.googlegroups.com...
Ben Thul
Nov 19, 2009, 2:13:08 PM11/19/09
to
Sorry for not getting back to this sooner...I've been head down in the
muck. To answer your question, I don't think that these articles
would have had virtual subscriptions since the publication that they
were a member of was set to immediate_sync=off and
allow_annonymous=off. Unfortunately, I had to drop and re-add the
publication to get it working, so I can't say for sure. Thanks for
your reply!
--
Ben
On Nov 17, 9:43 am, "Hilary Cotter" <hilary.cot...@gmail.com> wrote:
> These could be virtual subscriptions which you are seeing.
>
> Did you do a sp_refreshsubscriptions to update your publication for these
> new articles, and did you add them to the subscribers?
>
> "Ben Thul" <thul...@gmail.com> wrote in message
muck. To answer your question, I don't think that these articles
would have had virtual subscriptions since the publication that they
were a member of was set to immediate_sync=off and
allow_annonymous=off. Unfortunately, I had to drop and re-add the
publication to get it working, so I can't say for sure. Thanks for
your reply!
--
Ben
On Nov 17, 9:43 am, "Hilary Cotter" <hilary.cot...@gmail.com> wrote:
> These could be virtual subscriptions which you are seeing.
>
> Did you do a sp_refreshsubscriptions to update your publication for these
> new articles, and did you add them to the subscribers?
>
Paul Ibison
Nov 21, 2009, 10:56:28 AM11/21/09
to
OK - but for future reference you could also have solved it by adding the
articles and data manually to the subscribers (SSIS/DTS) and scripting in
the replication stored procedures - the distribution agent would have picked
them up and propagated changes.
HTH,
Paul Ibison
articles and data manually to the subscribers (SSIS/DTS) and scripting in
the replication stored procedures - the distribution agent would have picked
them up and propagated changes.
HTH,
Paul Ibison
0 new messages