SQL Server 2008 R2 Transactional Replication.

• satnam.singh 44358

  Ten Centuries

  Points: 1300

  More actions

  June 16, 2016 at 2:07 am

  #327178

  Hi,

  I have Transactional Replication enabled for our Service Desk Database on a SQL Server 2008 R2 environment. Data is getting replicated instantaneously. Since the past 1 week, I have been noticing the following message in the View Synchronization Status Log:-

  Job ABC started successfully.

  However i see a lot of commands of the following types in the Replication Monitor:-

  A LogReader Agent is Scanning the Transactional Log for commands to be Replicated. Approximately 2550000 log records have been scanned in Pass 3, 0 of which were marked for Replication, total elapsed time is 92665 seconds.

  I still believe that the Replication is working fine but the messages that I view in the Log Reader Agent and Synchronization Agent is pretty weird. Also in the Replication Monitor i see mere 30-32 commands waiting to be delivered but when i execute the below query against the ServiceDesk database on publisher, i see that the O/P fluctuates between 1000-100000 which i find something abnormal.

  SELECT count(*) FROM ::fn_dblog(NULL, NULL) WHERE Description='REPLICATE'

  Also as a last step, do i need to setup the entire process again?

  Any Help on this would be Greatly Appreciated.

  With Thanks,

  Satnam