Groups | Blog | Home
all groups > sql server replication > march 2007 >

sql server replication : Merge replication: subscriber jobs missing.


Hilary Cotter
3/20/2007 12:00:00 AM
There was a set of conditions which would cause the replication agents to
disappear. Basically if you restored a published database, and then create a
publication with the same name as the old one, everything would disappear.

By chance, where are the agents running? On the subscriber or publisher?

--
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]

Hilary Cotter
3/20/2007 12:00:00 AM
Not until I removed some publications.

--
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]

SQLdba
3/20/2007 6:15:07 AM
I didn't actually see this but my customer swears:

Merge replication subscriber sql 2000 sp3a had the jobs disappear from the
agent for about 10 hours and the publisher said it could not connect. This
morning the jobs are back and replication was able to be started manually.

SQLdba
3/20/2007 7:43:00 AM
They run on the publisher. When you say everything would disappear, did it
ever come back?


[quoted text, click to view]
SQLdba
3/20/2007 8:03:21 AM
Two things. First, it's transactional replication, not merge. Sorry for
that mistake.

Second, I was able to see the jobs when I looked at the server and was able
to restart the replication manually.


[quoted text, click to view]
AddThis Social Bookmark Button