Error Icons displayed on parent objects with no or different children -- sql server replication

troy
8/26/2005 9:22:36 AM

I recently had to restore a database from backup and the restored
database had a different set of publications than the one I overwrote.
Since then, in EM, on the Replication Monitor object, Publishers, and
Servername objects as well as on the Agents and Snapshot Agents
objects, I see the little red X denoting an error. I have done
everything i can think of and more, following much advice given on this
group. I even turned replication off, deleted all publications, used
hilary cotter's script to clean up all the miscellaneous replication
tables/settings, etc. and restarted the server.

Everything seems to be working fine, but I would like to try to clean
up these "errors". Does anyone have any suggestions?

I am running SqlServer 8.00.2039 SP4 Standard Edition on Windows Server
2003 SP1

Hilary Cotter
8/27/2005 6:15:57 AM

You will have to manually remove the replication jobs in msdb. Sometimes you
will get transitory error messages in EM, run sp_MSload_replication_status
to clear them.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

sql server replication : Error Icons displayed on parent objects with no or different children