Thread: SQL 2005 replication
08-24-06, 17:55 #1Registered User
- Join Date
- Sep 2005
Unanswered: SQL 2005 replication
We have upgraded our distribution servers to SQL Server 2005 from 2000 2 days ago. All our replication is transactional. Some replication is running through without any hassles, but others are just not doing anything. The logreader agent is running and succeeding, but not bringing any transacions through to the distribution, even though I can see there is about 9 hours worth of data sitting in on the publication that needs to be replicated. The tables on the publisher is still marked for replication, but when I run MSlogreader_history for the specific agent, it gives me the message: "Executed as user: DOMAIN\SERVICEACCOUNT. The step succeeded.", but it delivers no transactions and commands. It has been doing this for the last 8 hours.
What can I possibly still check to see what the problem is? Any suggestions are MORE that welcome!
P.S. Our replication has been running very stable in 2000 for the last 3 years and I have never come accross this before.
08-25-06, 01:23 #2Registered User
- Join Date
- Jan 2006
Check the errors in your distribution database.
select * from msrepl_errorsRajesh Patel
Everybody says - mistake is the first step of success, but it's not true. The correction of the mistake is the first step of success.