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: Tuesday, June 10, 2014 9:31 PM
Points: 3, Visits: 6
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: Today @ 2:05 AM
Points: 2,036, Visits: 1,378
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: Tuesday, June 10, 2014 9:31 PM
Points: 3, Visits: 6
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


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, July 14, 2014 2:06 PM
Points: 3,865, Visits: 7,130
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