Wednesday, March 7, 2012
replication monitor icon become red color
I just re-create replication and everything seems like ok. I can replicate
data into subscriber. Only on the replication monitor icon, it has red cross
icon. under it, in the treeview, each item has red color with cross icon. I
check the history, no error, and data has been transfer successfully. Can
some one tell me how to get rid of it? Thanks.
the replication is working fine, only replication monitor become red. The
agent is ok, no error in the history. I don't know why it is red cross on it.
"Iter" wrote:
> Hi guys,
> I just re-create replication and everything seems like ok. I can replicate
> data into subscriber. Only on the replication monitor icon, it has red cross
> icon. under it, in the treeview, each item has red color with cross icon. I
> check the history, no error, and data has been transfer successfully. Can
> some one tell me how to get rid of it? Thanks.
>
|||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 .
replication monitor error
When Replication monitor shows an error icon, I removed all the publication 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!
Thanks for using replmonitor.
Would you like provide more detailed repro steps? like how do you remove publicaiton jobs, delete jobs under sqlserveragent, or remove subscriptions? How did you reconfigure everything, did you disable distribution and publication, then recreate them?
Thanks
Yunjing
|||My problem has been resolved by restart sql server agent. Thank you!replication monitor error
When Replication monitor shows an error icon, I removed all the publication 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!
Thanks for using replmonitor.
Would you like provide more detailed repro steps? like how do you remove publicaiton jobs, delete jobs under sqlserveragent, or remove subscriptions? How did you reconfigure everything, did you disable distribution and publication, then recreate them?
Thanks
Yunjing
|||My problem has been resolved by restart sql server agent. Thank you!