SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Dropping Article


Dropping Article

Author
Message
Subhash-63067
Subhash-63067
Old Hand
Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)

Group: General Forum Members
Points: 353 Visits: 295
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
Nikhil Shikarkhane
Nikhil Shikarkhane
SSC Veteran
SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)SSC Veteran (232 reputation)

Group: General Forum Members
Points: 232 Visits: 203
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.
Subhash-63067
Subhash-63067
Old Hand
Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)

Group: General Forum Members
Points: 353 Visits: 295
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
MyDoggieJessie
MyDoggieJessie
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6662 Visits: 7393
Did you ever get an answer to this?

______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience" ;-)
Express12
Express12
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1452 Visits: 1058
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?

BT
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search