Hi.

I have a subsription that needs to be reinitialized because it has been
marked as inactive. Instead of reinitializing and then have to transfer
a new snapshot, that would caus all sorts of key violations, i would
like to do the following.

1.Drop the subscription.
2.Add subscription with option that the subscribers has the schema and
data.
3.Copy the pending transactions

The problem is, when you drop the subscription, the pending
transactions are truncated, so the question is.

How can i copy all the commands from the distribution agent, that is
supposed to go to a specific subscriber, so that i can just connect to
the subscriber and run them manually after i have set up the new
subscription?

Also have a second question.
We don't have a lot of changes, and it seems like having the log reader
running contuniously is not neccessary. Can i just change the log
reader job to run on a reccuring schedule with Enterprise Manager?

Than you!