SQL replication agent - Identify cause of event

  • Hi,

    I recently had a subscriber seemingly re-initialise without warning today.

    I'm not even sure if it was a re-initialise, the job history on the agent does not give any indication that anything has occurred outside of the date it was started 45 days ago.

    All I know is that when I checked the Replication Monitor the agent was bulk copying data into tables this morning.

    Is there anywhere I can look to see what triggered this?

    Running SQL Server 2005 with Contineous Merge Pushing data from publisher.

    Any thoughts or advice would be appreciated.

    G

  • What service pack are you running? Prior to SP3 there are some bugs that can cause a subscription to expire. For example http://support.microsoft.com/kb/953624

  • Hi and thanks for the info, unfortunately we are running SP3 so it had to be something else.

Viewing 3 posts - 1 through 2 (of 2 total)

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