"Tigermikefl" <Tigermikefl@discussions.microsoft.com> wrote in message
news:9818F2EF-039D-469B-97E7-880F405BBB71@microsoft.com...
> Excellent, thanks for the help.
>
> Why no-sync ? Advantages?
> How do I 'run validations'? With the agent profile or something else?
>
> Because the pubs/schema are changing so much, I planned to craft a script
> to
> drop old anon subscriptions on the msde's and create a new ones, which
> will
> reinit all their table data. The new pubs partition much better so this
> should take too long.
>
> Except for a dozen, which I figured to attach a subscription database for
> speed.
>
> What do you think?
>
> --
> Mike
>
> If data falls in the woods and nobody is there to see it ....... ?
>
>
> "Hilary Cotter" wrote:
>
>> I would run kick all users off all subscribers and the publisher, run the
>> merge agent one last time. Drop the subscriptions, drop the
>> publications(s),
>> re-create the publications, do a no-sync with all subscribers. Run the
>> merge
>> agents until they stop, and then run validations. If a subscriber is out
>> of
>> sync, reinitialize with the upload option.
>>
>> --
>> Hilary Cotter
>> Director of Text Mining and Database Strategy
>> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>>
>> This posting is my own and doesn't necessarily represent RelevantNoise's
>> positions, strategies or opinions.
>>
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>>
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>>
>>
>>
>> "Tigermikefl" <Tigermikefl@discussions.microsoft.com> wrote in message
>> news:C80F9B66-B15C-4ED5-941E-3D93D05EB5CF@microsoft.com...
>> >I want to drop all my pubs and add newly designed pubs in there place.
>> >4G
>> > db, sql 2Ksp4.
>> >
>> > I have 2 main server (1 pub pushing to the other) and 115 anon merge
>> > subscribers. I'd love to keep the two servers publications intact and
>> > drop
>> > all the metatable data for the anon subscribers.
>> >
>> > In short, what are the best practices to get a clean slate in the pubs
>> > and
>> > distribution tables?
>> >
>> > Just delete publication or disable replication in the server properties
>> > and
>> > reset to replicate? Other?
>> >
>> > Reinit all subscribers prior or will the delete publications do that
>> > already?
>> >
>> > Thanks for the help.
>> >
>> > --
>> > Mike
>> >
>> > If data falls in the woods and nobody is there to see it ....... ?
>>
>>
>>