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

sql server replication : Error in MERGE replication


Jacx
9/30/2007 8:59:02 PM
Hi ,
Recently due to storage problem i had to move all the databases to local
disk. The databases were in merge replication and the server was where the
replication was set.

I generated tje scripts for the replications and disabled the replication on
the server.
After moving the databases i executed the replication creation scripts but
then i faced the following errors in the merge agent

The merge process could not initialize the subscription.
(Source: Merge Replication Provider (Agent); Error number: -2147201011)
--------------------------------------------------------------------------------------
Invalid column name 'compensate_for_errors'.
(Source: ServerName (Data source); Error number: 207)
-------------------------------------------------------------------------
The system tables for merge replication could not be created successfully.
(Source: ServerName (Data source); Error number: 20008)
-------------------------------------------------------------------------

Can anybody please suggest where did i go wrong and also the solution to the
problem

Thanks in Advance.
Hilary Cotter
10/1/2007 8:23:38 AM
The compensate for errors switch was introduced with SQL 2000 SP4. Is it
possible that somehow you are running a different version or service pack
version of SQL Server in the new topology?

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

AddThis Social Bookmark Button