February 10, 2010 at 10:04 am
I have inherited an existing replication setup and I need to add a new publication to replicate.
I'm fairly new to replication and this is the first time I've added a new publication.
Up until now, I've just had to add a new article to existing publication.
The setup is one publisher to 11 subscribers, using push merge replication.
Each server is running sql server 2005 (Build 3790: Service Pack 2).
There is a mix of x64 and x86 processors.
I used the wizard when I added the publication to the publisher.
Then used the wizard to setup the first subscription.
I used the generated script from the first subscription to setup the others, just changing the name for each one.
The problem is that some of the servers worked and some did not.
The error I'm getting from the replication monitor is:
The merge process could not initialize the subscription. Ensure that the subscription registration exists at the publisher, and reregister the subscription if necessary.
(Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201011)
Get help: http://help/MSSQL_REPL-2147201011
Publication 'pubInv_Pricing' cannot be added to database 'Inventory', because a publication with a lower compatibility level already exists. All merge publications in a database must have the same compatibility level.
(Source: MSSQLServer, Error number: 21527)
Get help: http://help/21527
The compatibility of the database on each server is set to 90.
Using the system stp sp_helpmergepublication, the backward_comp_level of all the publications for this database is also 90.
I've tried restarting SQL server on both the publisher and subscriber and restarting the subscribing server.
Also, I've tried to reinitialize the subscription and generate a new snapshot.
I'm not sure how to proceed.
Thank you in advance.
Ben
July 17, 2016 at 1:39 am
.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply