Friday, March 30, 2012

Problems with transactional replication

I got transactional replication between two servers , two identical database
(one publusher and one subscriber, distributor is on publisher server),
everything works clear however a few days ago i got on
Replication Monitor --> Publishers --> MyServerName failed icon snapshot
agent, now on path above i have two publication one that i buil transactional
with 3 agents, and one snapshot i don't know how it created.
Also when i trying to remove it i got the following message description
couldn't retrive information about publication, ... .... ... publication
name not found in the TransPublication collection.
Any ideas ? TNX
Message posted via http://www.droptable.com
You have inconsistent meta data in your distribution database. The best way
to fix this is unfortunately to start carefully editing the metadata tables.
Sometimes it is better to live with these phantom messages.
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
"akej via droptable.com" <forum@.droptable.com> wrote in message
news:507682708C7A4@.droptable.com...
> I got transactional replication between two servers , two identical
database
> (one publusher and one subscriber, distributor is on publisher server),
> everything works clear however a few days ago i got on
> Replication Monitor --> Publishers --> MyServerName failed icon
snapshot
> agent, now on path above i have two publication one that i buil
transactional
> with 3 agents, and one snapshot i don't know how it created.
> Also when i trying to remove it i got the following message description
> couldn't retrive information about publication, ... .... ... publication
> name not found in the TransPublication collection.
>
> Any ideas ? TNX
> --
> Message posted via http://www.droptable.com
|||>carefully editing the metadata tables
I don't really understande what does it mean, can u explain me plz?
Message posted via http://www.droptable.com
|||somebody can help me with problem that i experiance
Message posted via http://www.droptable.com

No comments:

Post a Comment