Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Dropping Article Expand / Collapse
Author
Message
Posted Thursday, October 02, 2008 12:22 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 07, 2013 11:45 AM
Points: 169, Visits: 282
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
Post #579882
Posted Thursday, October 02, 2008 6:56 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 06, 2011 11:54 AM
Points: 154, 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.
Post #580007
Posted Thursday, October 02, 2008 8:21 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 07, 2013 11:45 AM
Points: 169, Visits: 282
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
Post #580031
Posted Monday, February 20, 2012 2:42 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, April 21, 2014 7:46 PM
Points: 3,738, Visits: 7,081
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"
Post #1254937
Posted Thursday, May 16, 2013 7:23 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 12:53 PM
Points: 652, Visits: 928
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
Post #1453517
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse