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

sql server replication : Replication Validation error


hughtwg NO[at]SPAM yahoo.com
10/5/2007 8:25:37 AM
I've created a snapshot replication between two servers. When I try to
validate the subscription I get the following error:
Error 20523: Could not validate the article 'categories'. It is not
activated.

I have looked at the 'categories' table in both servers and it appears
that it is being updated correctly.

I have not been able to find any information on this error or how to
resolve it. Any information you could provide would be greatly
appreciated.

thanks,
Hugh
Hilary Cotter
10/8/2007 12:00:00 AM
Did you add or drop this article to the publication or subscription by
itself? It sounds like the snapshot agent has not been run for this article.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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]

hughtwg NO[at]SPAM yahoo.com
10/9/2007 9:13:02 AM
No this table was part of the original publication. Is there a way to
force the snapshot agent to pick up this article/

thanks,
Hugh


[quoted text, click to view]


Hilary Cotter
10/10/2007 10:09:54 PM
use sp_droparticle to remove it from the publication, and then sp_addarticle
to add it back. Following this do an sp_refreshsubscriptions


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