Hello replication guru's;

I'm planning to implement a SQL2000 transactional replication republisher
model. My question is, when you need to manually re-snapshot the data to
the Publishing Subscriber, how do you handle the subscribers to it, i.e;

Do you set up table articles to delete all the data in the Publishing
Subscriber and re-insert it all? I'd assume you have to, as you can't
drop/re-create the tables in the Publishing Subscriber b/c after all, they
are also used to publish to subscribers.

If you do choose to delete all the data and re-insert it when you do a
snapshot to the publishing subscriber, doesn't this create a huge amount of
sp_MSins and sp_MSdel commands to be then pushed down to the publishing
subscriber's subscribers?

or,

Should you drop the publications from the Publishing Subscriber to the
Subscribers and re-set them up after the snapshot completes from the
Publisher/Distributor to the Publishing Subscriber? This seems like it
would be faster, but require quite a bit more manual intervention...

tia for any ideas you might be able to share,
--oj.

if i am correct , you have server replication chain like this:
p1->s1->s2
and you want to re-init s1 and s2 with p1.

you can not use drop/recreate from p1-> s1 because all tables you have
published to s2 are not allowed to drop on s1.

you only can break publication from s1 to s2 then re-create publication to
s1 then s2 later.