Hello again,
The root node of my SQL Server replication monitor is showing a red X but
all the actual replications listed underneath are OK. What might be causing
this and how can I get rid of it! My DBA is getting twitchy...
Thanks
Will
If you run profiler and navigate to the replication monitor, you should see
why this is happening. The replication monitor gets its info from
tempdb.dbo.MSreplication_agent_status and running
sp_MSload_replication_status refreshes this table. As restarting the SQL
Server Service causes the tempdb to be recreated from the model database,
this also removes the problem.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment