Wednesday, March 7, 2012

replication monitor

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
this before?
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
"bjones" <bjones@.discussions.microsoft.com> wrote in message
news:131B5C87-9D38-42E6-9627-E4C8AF022C4F@.microsoft.com...
>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
> this before?
|||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?
"Hilary Cotter" wrote:

> 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
> "bjones" <bjones@.discussions.microsoft.com> wrote in message
> news:131B5C87-9D38-42E6-9627-E4C8AF022C4F@.microsoft.com...
>
>
|||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
"bjones" <bjones@.discussions.microsoft.com> wrote in message
news:94C95374-EDD5-40C9-AC80-FCBE95FA02EC@.microsoft.com...
> publication, distribution and subscription agents run on the same server.
i
> have tried reinstalling with the same result. is there a sysservers or
some[vbcol=seagreen]
> other system related value which might be causing this to fail?
> "Hilary Cotter" wrote:
case.[vbcol=seagreen]
it.[vbcol=seagreen]
monitor[vbcol=seagreen]
distribution[vbcol=seagreen]
anyone[vbcol=seagreen]
|||Hi Hilary
I have the below and tried registring the distribution server. However
nothing appears under the server when expanding the monitor.
"Hilary Cotter" wrote:

> 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
> "bjones" <bjones@.discussions.microsoft.com> wrote in message
> news:94C95374-EDD5-40C9-AC80-FCBE95FA02EC@.microsoft.com...
> i
> some
> case.
> it.
> monitor
> distribution
> anyone
>
>
|||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?
"bjones" wrote:
[vbcol=seagreen]
> Hi Hilary
> I have the below and tried registring the distribution server. However
> nothing appears under the server when expanding the monitor.
> "Hilary Cotter" wrote:
|||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
"bjones" <bjones@.discussions.microsoft.com> wrote in message
news:F8437637-C2E3-42A0-B2EF-3158646F3D36@.microsoft.com...
> The distribution and log agents seem to be down because they couldn't
connect[vbcol=seagreen]
> 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?
> "bjones" wrote:
Replication?[vbcol=seagreen]
server.[vbcol=seagreen]
or[vbcol=seagreen]
the[vbcol=seagreen]
reinstall[vbcol=seagreen]
replication[vbcol=seagreen]
show[vbcol=seagreen]
|||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?
"Hilary Cotter" wrote:

> 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
> "bjones" <bjones@.discussions.microsoft.com> wrote in message
> news:F8437637-C2E3-42A0-B2EF-3158646F3D36@.microsoft.com...
> connect
> Replication?
> server.
> or
> the
> reinstall
> replication
> show
>
>
|||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
"bjones" <bjones@.discussions.microsoft.com> wrote in message
news:0F7D1163-6200-40AB-9BF6-5E00AA7DA8FF@.microsoft.com...
> 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[vbcol=seagreen]
> publication other than the distribution/subscription cleanup jobs?
> "Hilary Cotter" wrote:
you[vbcol=seagreen]
when[vbcol=seagreen]
the[vbcol=seagreen]
However[vbcol=seagreen]
same[vbcol=seagreen]
sysservers[vbcol=seagreen]
this is[vbcol=seagreen]
replication ->[vbcol=seagreen]
has[vbcol=seagreen]

No comments:

Post a Comment