none
subscriptiontstreams always chang to single

    Question

  • hi:

      My relication is transaction replication. I create 32 streams do the job.But awayls change to single stream after hours. I found no any error in log and .err file on both distributor and subscriber.what's wrong? please help me.

    Wednesday, November 21, 2012 3:01 AM

Answers

  • The distribution agent will switch to use only one session if one of the sessions raises an error or if the blocking monitor thread detects blocking.  Some of the errors will not be automatically be logged by SQL Server.

    To determine why the distribution agent has switched to use only one session, please follow the steps in the section How to troubleshoot a Distribution Agent that switches to use only one session in this KB article:  http://support.microsoft.com/kb/953199.


    Brandon Williams (blog | linkedin)

    • Marked as answer by Archer long Wednesday, November 28, 2012 10:39 AM
    Wednesday, November 21, 2012 3:42 AM