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
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
"troy" <troyblakely@.gmail.com> wrote in message
news:1125073355.972990.114690@.g47g2000cwa.googlegr oups.com...
> 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
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment