Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replication Action Message Expand / Collapse
Author
Message
Posted Tuesday, May 14, 2013 7:00 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, July 28, 2014 12:54 PM
Points: 50, Visits: 772
Hi Experts,

We have set up a brand new replication it was working fine till yesterday, today all of sudden logs stopped going to distributor and when I checked replication monitor it was giving me this messages in Publisher to Distributor history

The Log Reader Agent is scanning the transaction log for commands to be replicated. Approximately 365500000 log records have been scanned in pass # 3, 0 of which were marked for replication, elapsed time 882402 (ms).

the pass was at 1 and then it went to 3

can any one explain me why this happens ???
and what is the best way to solve it.
the tracer token was not able to go from Publisher to Distributor also!!!

Thank you for your help


Post #1452892
Posted Wednesday, May 22, 2013 8:55 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 1:21 PM
Points: 809, Visits: 1,160
Any other error message?

Check this article. it might help.

http://blogs.msdn.com/b/chrissk/archive/2009/05/25/transactional-replication-conversations.aspx
Post #1455563
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse