>-----Original Message-----
>sql2k sp3
>
>I know the title sounds bizarre. But its true. I was
doing
>some disaster recovery testing to find out what would
>happen if our Publisher box needed to be restored from
>backups. I had all my backups so then I uninstalled/
>reinstalled SQL, sp3, and a hotfix. I did all the
restores
>successfully. First Master, then MSDB, Distribution, and
>my user DB. All Publications, Articles, Subscriptions are
>intact as expected. The Log Reader and Distribution
Agents
>are running. The Status is Active for the Subscription.
>All appears healthy. Then I insert one row of data. The
>Log Reader Agent says it copied 1 row, but the
>Distribution Agent never does. It never appears in the
>Subscription table either. I ran sp_browsereplcmds and
its
>empty. Ive dont this type of testing before and never run
>into this. My data isnt replicating or blowing up.
>
>Any ideas?
>TIA, Chris
>.