June 10, 2008 at 7:53 am
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.
doing transactional replication. log reader is running all the time and the distribution agent runs once evey 15 mins.. can anyone help?????
June 10, 2008 at 2:51 pm
Did you check the snapshot folder for any script that is genrated for the newly added article once snapshot agent complete its execution?
There should be three files(I think) for the newly added article there.
Manu
June 11, 2008 at 7:54 am
I cannot find a snapshot folder on my publishing server.
what would be the correct steps to drop and recreate this article for relication?
June 12, 2008 at 11:52 am
can anyone help me with the proper steps to drop this article from the subscription and then re-add it?
June 16, 2008 at 8:55 am
successfully Dropped my article from the publication using sp_droparticle.
I truncated the table on my subcriber side and then did a snaphot and let everything sync back up.
I re-added the article to the publication through Enterprose Manager.. this one table will not replicate!!! Can anyone tell me what I'm fdoing wrong>?
June 23, 2008 at 2:32 am
Can you check that the article is actually being subscribed. I know you've added it back to the publication but check the table MSsubscriptions in the Distribution database.
The normal process to removing and adding articles would be
Drop subscriptions to the article
Drop the Article from the publication
...make changes
Add the article to the publication
Add subscriptions to the article
HTH
Graeme
June 23, 2008 at 2:58 am
Thank you so much for your help and please excuse my ignorance but.... the mssubscription table lists the articles by Article ID number, how do I get the ID number for my article?
June 23, 2008 at 5:19 am
Look at MSArticles in the Distribution database
June 23, 2008 at 5:54 am
Thanks. I looked and got my article ID and then checked mssubscriptions and my article is NOT defined in that table.
I tried to add it
sp_addsubscription @publication = 'TowerDB to KOCSQL03'
, @article = 'Tower.cbl'
, @subscriber = 'kocsql03'
, @destination_db = 'Towerdb'
and I get this error:
Server: Msg 208, Level 16, State 1, Procedure sp_addsubscription, Line 135
Invalid object name 'syspublications'.
June 23, 2008 at 8:56 am
Are you running this against the Publishing database?
June 23, 2008 at 8:59 am
when I run it against the publishing DB I get this :
Server: Msg 14100, Level 16, State 1, Procedure sp_addsubscription, Line 240
Specify all articles when subscribing to a publication using concurrent snapshot processing.
June 23, 2008 at 9:30 am
Hmmm...
When you have the concurrent snapshot option set, I think the only thing you can do is drop the subscriptions totally, add the article and resynch with a totally new snapshot...
I believe there are some 'backdoor' options. But I would not advise these on a production environment.
Sorry I cannot be more helpful
Regards
Graeme
June 23, 2008 at 9:38 am
i guess I don't understand what you mean.. are you talking about re-building the entire subscription? Can I script that out somehow? This is a prodcution environment and I'm not sure I'm ready to rebuild this whole thing.. They have added individual articles to this publication in the past.. I don't know why I'm having such a time with this one.
June 23, 2008 at 9:44 am
Yes you may have to drop the subscriptions, add the articles then push out a completely new snapshot...yes not ideal.
You could set up another publication for the new article(s)...that way you are not interfering with your main publication. Then if you have a quiet weekend you could include the article in the main publication...at least you would have some form of data transfer
Graeme
June 23, 2008 at 10:50 am
: ) Thank you for all your help!!!
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply