Replciation Monitor in RED State

Question

Replciation Monitor in RED State

narayanamoorthy.a

Ten Centuries

Points: 1256
More actions
March 5, 2014 at 6:34 am

#284299

Hi,
I am using SQL Server 2000 8.00 version. I have an issue with replication monitor being in RED mark along with the publisher and distributor agents. Glad if anyone can throw some light on this.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lempster SSCoach Points: 15651 More actions · Answer 1

There will be some sort of error message within Replication Monitor to go with the 'red' mark (a red 'X' I assume): what does the error message say?

Regards

Lempster

narayanamoorthy.a Ten Centuries Points: 1256 More actions · Answer 2

I could not see the logs any. When I right click replication monitor I can see Perf monitor distributor property

MyDoggieJessie SSC-Forever Points: 44486 More actions · Answer 3

Right-clicking on the Agent should give you the option to "View Details", then switiching between tabs (of the Publisher/Distributor) you should see the last error that was recorded there).

Since all these tabs are simply reporting based upon a SQL Agent Job on either your Publisher/Distributor server's, you can also go view the job history for each of the Agents throwing the error.

Or, you can also runSELECT * FROM MSrepl_errors order ORDER BY time DESC

______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience