"Jimmy" <anonymous@discussions.microsoft.com> wrote in message
news:9dc801c43447$43f3a5a0$a601280a@phx.gbl...
>
> If I have a subscription to a publication (transactional)
> and the Distribution Agent tells me I need to
> reinitialize.
>
> What are the steps to do this??
>
> Do I need to delete all the data on the subscriber?? If
> so, is there a way around this?? If not, what is the best
> practice of accomplishing this?
>
> What if there are changes made at the subscriber do I
> loose them if the subscription is reinitializatized??
>
> Thanks...

>-----Original Message-----
>Jimmy,
>reinitialize means apply a new snapshot, so, you'll need
to run the snapshot
>agent first then run the distribution agent. When you
say will it delete all
>the data on the subscriber, I'm not sure why this is a
concern. For
>transactional replication, the subscriber data is
treated as RO data. If
>however someone has edited the data, then you could use
binary checksums to
>see what has changed and then do the same changes on the
publisher. If the
>subscriber is using updatable transactional replication
then the changes are
>already on the publisher. If you're using a queue, then
be sure to run the
>queue reader to send up the changes.
>HTH,
>Paul Ibison
>
>
>.