March 19, 2005 at 2:26 am
Hi Guys,
I've seen another post like my problem but I think it wasn't quite the same.
We have recently dropped and reapplied replication to our production environment....no problems..phew!
However, the Logreader is showing as failing/errors i.e. the dreaded red circle has appeared. But, the reader appears to be working correctly.
Any thoughts?
Cheers...Graeme
March 19, 2005 at 7:44 am
Hi again,
As an addition to my initial message.
I would like to say that the red error circle only appears on the logreader folder...not on any logreader agent.
Very strange!
Thanks....Graeme
March 21, 2005 at 5:11 am
Hello again,
After a bit of digging...I have resolved the issue.
For your information :
In TempDB there is a table called MSReplication_Merge_Status, this contains the current status of the agents (surprisingly enough). There are 4 possible status conditions 1,2,3 and 4. 2 represents 'Success'. Against my Logreader, the status was set to 6 therefore invalid. Although the agent was running ok SQL was reporting it as not. Therefore I updated the status to 2, refreshed and...as if by magic..all back to normal.
Hope this is of use.
Regards...Graeme
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply