Replication Monitor - Publisher is empty, but my replication is still there and working

I have a wired situation..!
I set up transactional replication on one of my development server (SQL
2000 Dev Edition with sp4).
It is running fine without any issues and all of a sudden, i noticed in
my repication monitor tab under Publisher where I usually see the
publication is empty now.
I do see the snapshot agent, log reader and distribution agent under my
agents inside the replication Monitor. But its usefull to see all 3
agents in one window under publisher before. What happend? Is there any
way to get that inside that monitor? Has someone encountered this
sitation before? Please advise...
After that I tried to create a new set of replication on different
database on the same server and i dont see those either under
Replication Monitor - Publishers...
All it says is (No Items)...
I would appreciate any help to correct this issue... Thanks in advance..
Which account are you using to connect to the EM?
"Query Builder" <querybuilder@.gmail.com> wrote in message
news:1162496955.745756.103220@.e3g2000cwe.googlegro ups.com...
>I have a wired situation..!
> I set up transactional replication on one of my development server (SQL
> 2000 Dev Edition with sp4).
> It is running fine without any issues and all of a sudden, i noticed in
> my repication monitor tab under Publisher where I usually see the
> publication is empty now.
> I do see the snapshot agent, log reader and distribution agent under my
> agents inside the replication Monitor. But its usefull to see all 3
> agents in one window under publisher before. What happend? Is there any
> way to get that inside that monitor? Has someone encountered this
> sitation before? Please advise...
> After that I tried to create a new set of replication on different
> database on the same server and i dont see those either under
> Replication Monitor - Publishers...
> All it says is (No Items)...
> I would appreciate any help to correct this issue... Thanks in advance..
>
|||I think your subscription has expired and being dropped. Check to see if the
job exists in the jobs folder, it will have a name similar to the
publication.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Query Builder" <querybuilder@.gmail.com> wrote in message
news:1162496955.745756.103220@.e3g2000cwe.googlegro ups.com...
>I have a wired situation..!
> I set up transactional replication on one of my development server (SQL
> 2000 Dev Edition with sp4).
> It is running fine without any issues and all of a sudden, i noticed in
> my repication monitor tab under Publisher where I usually see the
> publication is empty now.
> I do see the snapshot agent, log reader and distribution agent under my
> agents inside the replication Monitor. But its usefull to see all 3
> agents in one window under publisher before. What happend? Is there any
> way to get that inside that monitor? Has someone encountered this
> sitation before? Please advise...
> After that I tried to create a new set of replication on different
> database on the same server and i dont see those either under
> Replication Monitor - Publishers...
> All it says is (No Items)...
> I would appreciate any help to correct this issue... Thanks in advance..
>
|||I am connected thru EM using the SA account. I also have adimin rights
thru windows authentication...
How do I check my subscriptions are expired or not? I created a new
replication for testing and it is also working fine but i dont see the
replication in the replication monitor.. I do see the publications
under the replication--> publication tree...
THanks for all your input. I would apprecate if you can help me figure
this out...! Thanks again
On Nov 3, 6:34 am, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:[vbcol=seagreen]
> I think your subscription has expired and being dropped. Check to see if the
> job exists in the jobs folder, it will have a name similar to the
> publication.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com
> "Query Builder" <querybuil...@.gmail.com> wrote in messagenews:1162496955.745756.103220@.e3g2000cwe.go oglegroups.com...
>
>
>
|||I still have this issue.. Any thoughts? ... ideas.. ?
Thanks in advance..
Query Builder wrote:[vbcol=seagreen]
> I am connected thru EM using the SA account. I also have adimin rights
> thru windows authentication...
> How do I check my subscriptions are expired or not? I created a new
> replication for testing and it is also working fine but i dont see the
> replication in the replication monitor.. I do see the publications
> under the replication--> publication tree...
> THanks for all your input. I would apprecate if you can help me figure
> this out...! Thanks again
>
> On Nov 3, 6:34 am, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
|||I still have this issue.. Any thoughts? ... ideas.. ?
Thanks in advance..
Query Builder wrote:[vbcol=seagreen]
> I am connected thru EM using the SA account. I also have adimin rights
> thru windows authentication...
> How do I check my subscriptions are expired or not? I created a new
> replication for testing and it is also working fine but i dont see the
> replication in the replication monitor.. I do see the publications
> under the replication--> publication tree...
> THanks for all your input. I would apprecate if you can help me figure
> this out...! Thanks again
>
> On Nov 3, 6:34 am, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
|||I finally figured out the issue... I had the sql names changed.. when I
changed it back, the replications appeared under the replication
monitor tab...
So the moral of the whole story(issue) is never change SQL jobs
associated with replication.. It will disspear from the replication
monitor group...
Query Builder wrote:[vbcol=seagreen]
> I still have this issue.. Any thoughts? ... ideas.. ?
> Thanks in advance..
> Query Builder wrote: