Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Replciation Monitor in RED State Expand / Collapse
Author
Message
Posted Wednesday, March 5, 2014 6:34 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 2:26 AM
Points: 35, Visits: 63
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.
Post #1547764
Posted Wednesday, March 5, 2014 7:52 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, January 27, 2016 7:06 AM
Points: 2,657, Visits: 1,657
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
Post #1547800
Posted Wednesday, March 5, 2014 8:38 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 2:26 AM
Points: 35, Visits: 63
I could not see the logs any. When I right click replication monitor I can see Perf monitor distributor property
Post #1547849
Posted Wednesday, March 5, 2014 9:10 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 6:06 PM
Points: 4,717, Visits: 7,321
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 run
SELECT * FROM MSrepl_errors order ORDER BY time DESC



______________________________________________________________________________
"Never argue with an idiot; They'll drag you down to their level and beat you with experience"
Post #1547873
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse