Groups | Blog | Home
all groups > sql server replication > may 2005 >

sql server replication : replication monitor


bjones
5/14/2005 6:55:14 AM
i have setup replication on server mssql v7.0, but the replication monitor
does not display. have also tried via tools -> replication -> show
replication monitor.But after selecting the server with the distribution
database, it does not expand any further to show the agents. has anyone seen
bjones
5/14/2005 8:40:01 AM
publication, distribution and subscription agents run on the same server. i
have tried reinstalling with the same result. is there a sysservers or some
other system related value which might be causing this to fail?

[quoted text, click to view]
bjones
5/14/2005 9:15:23 AM
Hi Hilary

I have the below and tried registring the distribution server. However
nothing appears under the server when expanding the monitor.

[quoted text, click to view]
bjones
5/14/2005 9:38:01 AM
The distribution and log agents seem to be down because they couldn't connect
to the subscriber. I am not sure how to check their status and restart the
agents without the monitor gui. any advise on how to do this?

[quoted text, click to view]
bjones
5/14/2005 10:19:02 AM
i did script it out because the gui would not allow me to set up the
publication and distribution which is why i was thinking it was related to
sysservers or something. i appear to have 4 distribution jobs and not sure
which was is valid. is there supposed to be only one distribution job for 1
publication other than the distribution/subscription cleanup jobs?

[quoted text, click to view]
Hilary Cotter
5/14/2005 11:02:16 AM
Do you have a remote distributor? It will show up there if this is the case.
If not, something seems hosed. I would remove replication and reinstall it.
--
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
5/14/2005 12:09:23 PM
No, do you have the show replication monitor group in Tools - Replication?

--
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
5/14/2005 1:02:15 PM
you should be able to find them in the management folder. It might be a
little hard to identify them - but the category should help.

BTW - did you script out your publications and then re-rerun them. If you
are not careful when editing your publication scripts and assigning new
agent names and publication name it can cause your jobs to disappear when
you look in the agents folder.

--
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
5/14/2005 6:47:23 PM
Can you go to your subscriber or another machine and register the publisher
in EM, and then take a look at replication monitor? I'm trying to find out
if there is something wrong with your publisher setup, or just the EM MMC on
your machine.

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

AddThis Social Bookmark Button