July 14, 2005 at 8:20 am
Dear all,
I hope somebody has a clue on this one. I searched all over the net but couldn't find any answers at all.
I have a server that was part in a merge replication as the subscriber to an existing publication. The subscribtion has been deliberalty removed (via MMC) to subscribe it to another distributor (which successfully replicates with other sites), but when trying to make the new subscription to apply the fresh snapshot, I receive the following errors :
The merge process could not initialize the subscription.
(Source: Merge Replication Provider (Agent); Error number: -2147201011)
--------------------------------------------------------------------
Invalid column name 'compensate_for_errors'.
(Source: SERVER_NAME (Data source); Error number: 207)
--------------------------------------------------------------------
The system tables for merge replication could not be created successfully.
(Source: SERVER_NAME (Data source); Error number: 20008)
--------------------------------------------------------------------
And the subscribtion does not get created. I noticed some MSmerge_* tables where still present in the database although it was "off" replication, so I deleted those but till the same error.
SQL is 8.00.858 on both servers. The only answer I found in one forum is too check the SP level which needs to be the same on both sides which is the case.
Any help would be extremely appreciated.
Thanks,
Joris.
July 15, 2005 at 1:51 pm
By running this query:
select object_name(id) from syscolumns where name = 'compensate_for_errors'
I got:
sysmergearticles
sysmergeextendedarticlesview
If you're sure you don't need them, you might try deleting those tables.
There's also a remove replication sp somewhere, but I'm not sure how comprehensive it is.
Dylan
Dylan Peters
SQL Server DBA
July 25, 2005 at 1:27 pm
Thanks for the tip mate. It WAS the old repl subscription causing the problem. I found the sp you are referring to (sp_removedbreplication) ran it from master (not from the dB concerned) and all is OK. I think this is a valuable tip, I couldn't find it nowhere else.
Kind regards.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply