December 16, 2011 at 10:53 am
In a transactional replication of a Publication containing multiple articles, is it possible to reinitialize only 1 article of many?
We have 200 tables being replicated transactionally. 1 of the tables is out of sync. We would like to reinitialize just this 1 table (containing just 6000 rows) instead of all 200 tables which occupy 500 GB of space..
Is this possible?
December 16, 2011 at 4:34 pm
Can't you just drop and add the article and then run the snapshot?
December 19, 2011 at 4:03 am
The previous comment is correct. Dropping the article and readding it is the way to do this.
-sp_dropsubscription
-sp_droparticle
-sp_addarticle
-sp_addsubscription
If you arent sure on the syntax for the above, script out the existing publication (both drop and create) and cut out the correct statements for the articles. Make sure you drop the subscriptions for just the article in question and not all.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply