October 2, 2008 at 12:22 pm
I have a publication with 10 tables as articles and which is subscribed.
Now I want to remove one of the article (which i don't want to publish) - I have opended thes SSMS Replication -- Local Publicaitons -->select the publication -->properties-->articles and uncheck the article which i dont want to publish.
Now the article from MS says (http://msdn.microsoft.com/en-us/library/ms152493(SQL.90).aspx) After dropping an article from a publication, you must create a new snapshot for the publication (and all partitions if it is a merge publication with parameterized filters).
do i need to really take a snapshot of my publicaitons ?? . After removing the article my replication is working except for the removed tables (i wanted in this way).
So can somebody explain me what that step mean in the MS artticle? what will happend if i don't take a snapshot?
subban
October 2, 2008 at 6:56 pm
Re-initializing is only required for Merge Replication and more to it if the following conditions are true :-
From BOL
1. If an article is a parent article in a join filter or logical record relationship, the relationships must be dropped first, which requires reinitialization.
2.If an article has the last parameterized filter in a publication, subscriptions must be reinitialized.
If you have snapshot or transactional replication then you need not worry. Unless you want to synchronize subscriber with the new publication.
October 2, 2008 at 8:21 pm
Still not clear.
See the words from BOL
For snapshot or transactional publications, articles can be dropped with no special considerations prior to subscriptions being created. If an article is dropped after one or more subscriptions is created, the subscriptions must be dropped, recreated, and synchronized. For more information about dropping subscriptions, see Subscribing to Publications and sp_dropsubscription (Transact-SQL). sp_dropsubscription allows you to drop a single article from the subscription rather than the entire subscription.
My situation is i have 10 articles published and subscribed. If i drop one article from SSMS or using sp_droparticle,
Do I need to take snapshot Again ?
Do i need to reinitialize the subscription again?
Will my replication for the remaining 9 tables continue to work without doing the above two (snapshot & reinitializaton)?
subban
February 20, 2012 at 2:42 pm
Did you ever get an answer to this?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
May 16, 2013 at 7:23 am
I also have a publication transactionally replicating 100 articles (some very large) and the need to DROP 1 small article.
Using SQL Server 2008 R2, do I need to re-Snap and Apply the entire HUGE snasphot when dropping just the 1 articel?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply