Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 2:06 AM
Points: 9, Visits: 16
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: Friday, December 12, 2014 7:23 AM
Points: 2,128, Visits: 1,487
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
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 2:06 AM
Points: 9, Visits: 16
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: Monday, November 24, 2014 5:46 AM
Points: 4,025, Visits: 7,172
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