February 28, 2010 at 12:43 pm
I have sql server 2005, I am having an issue where the transactions are sitting at the distributor and not going to subscriber. And I am seeing a pending status under distributor to subscribur. This replication is a continuous Transactional replication and not updatable.
I tried all the options like restarting sql server, reinitialized the subscription and nothing is working.
Please help!!
February 28, 2010 at 7:58 pm
Is there an error for the distribution agent?
March 1, 2010 at 11:22 am
Just for your information,
Log reader Job : reads the transaction log data which is changed and move to distribution database.
Distributor Job: distributes /transafers the data to subsriber.
Please see. log reader and distributor jobs are running.
HTH
Vinay
Thanx.
Vinay
http://rdbmsexperts.com/Blogs/
http://vinay-thakur.spaces.live.com/
http://twitter.com/ThakurVinay
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply