Winash,

Thanks a lot for the information. We have finally decided to rebuild the replication; we believe that is the safest and easiest way as a solution. But we have learnt...

To confirm if you're facing this error because of the same criteria that I faced:

a) Have you set the MaxCmdsInTrans switch for the log reader agent?

b) If you have set...

I just saw this error too on the Log agent for not starting up:

Cannot insert duplicate key row in object 'dbo.MSrepl_transactions' with unique index 'ucMSrepl_transactions'.Cannot insert duplicate key row in...

There is no undelivered commands for the distribution DB.

So last replication happened at 2am today morning and there are lots of data that have not been delivered to the Subscriber....

Winash,

i have posted a reply on the other thread; let's continue there.

Thanks for your help.

Undistributed commands keep telling 0.

What is the result of this on the distribution DB:

SELECT SUM(rows) FROM sys.partitions WHERE object_id = OBJECT_ID('msrepl_commands');

Result: 4321764

I have ran your script as well and below...

It is a Transactional replication.

The no replicated commands is at the Distributor only.

I can see the log reader sending commands frequently to the Distributor. The distributor is growing fast.

I made...

Hi Danny,

Had you solve this problem. I am getting the same with "No replicated transactions are available" while i know there is a very big process running at the publisher.

Thanks.

Vellen

yeah, good point; it might have come from the publisher.

Actually, we initialized the subscriber through datafile copy:

1. We configured the Distributor.

2. We configured the Publisher.

3. Set 'allow initialization through backup'...

Gail,

The steps you gave, worked wonderfully well. I did exactly what you said and Subscriber was not in Replication under Log_Reuse_Wait. I still perplexed how come this happened since the...

Hi Gail,

Thanks for the quick response.

Just to confirm before i implement the new replication, I have run DBCC OpenTran at the subscriber and below is the result. Does this means...