dbTalk Databases Forums  

How to remove replication monitor error icon completely

microsoft.public.sqlserver.replication microsoft.public.sqlserver.replication


Discuss How to remove replication monitor error icon completely in the microsoft.public.sqlserver.replication forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
she
 
Posts: n/a

Default How to remove replication monitor error icon completely - 05-08-2006 , 07:17 PM






When Replication monitor shows an error icon, I removed all the replication
jobs completedly. After I reconfigured publishing, subscriber,Distribution,
why the replication monitor still shows an error icon even though there is no
replication job scheduled?



Thank you!



Reply With Quote
  #2  
Old   
Paul Ibison
 
Posts: n/a

Default Re: How to remove replication monitor error icon completely - 05-09-2006 , 03:11 AM






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
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)



Reply With Quote
  #3  
Old   
she
 
Posts: n/a

Default Re: How to remove replication monitor error icon completely - 05-09-2006 , 05:35 PM



Paul:
Thank you so much! You resolved my problem.

"Paul Ibison" wrote:

Quote:
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
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)




Reply With Quote
  #4  
Old   
she
 
Posts: n/a

Default Re: How to remove replication monitor error icon completely - 05-09-2006 , 06:52 PM



I used the method you suggested and it resolved one the of server's
Replication monitor error icon problem.

However another server has two replication jobs. One of the publications
has been removed, when I was trying to delete the publication that has an
error icon, I could not delete it. I got the message :sql server Enterprise
Manger could not retrieve information about publication
'TheNameOfReplication'.
Any suggestions? Thanks.

"Paul Ibison" wrote:

Quote:
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
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.