SQL2003 Replication Monitor

  • When I view my Publication,I have 15 Items shown.2 have a status of Retrying and 1 as Failed.

    How can I reset these agents.

    the 2 at retrying are stuck because of replication problems with

    '...could not change generation history at the publisher'.

    during the merge process

  • Go to the replication menu, there you will see the sql agents listed.

  • Go to the replication menu, there you will see the sql agents listed.

  • CAN I REMOVE THE ENTRY FROM THE REPLICATION MONITOR ?

  • Only by dropping subscriptions will it be removed from repl mon. Set your timeout to unlimited or to a high value for merge agent.

    ChrisB MCDBA

    MSSQLConsulting.com

    Chris Becker bcsdata.net

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply