compatibility of publisher, subscriber and distributor

Question

Right now, I am running on production the transactional replications:

Publisher SQLServer 2000 sp4 standard edition
Distributor SQLServer 2005 (@@version = Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) )
Subsriber SQLServer 2000 sp4 standard edition

I am going to replace a subscriber server with the new one with SQLServer 2008 R2 standard edition installed. When I am trying to add SQLserver 2008 as a subscriber (@@version=Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) ), I'm getting an error message "the selected Subscriber does not satusfy the minimum level of the selected publication"

this is what Books Online says (link - ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10sq_GetStart/html/9926a4f7-bcd8-4b9b-9dcf-5426a5857116.htm):

A Subscriber to a transactional publication 
can be any version within two versions of the Publisher version. 
For example: a SQL Server 2000 Publisher running can have SQL Server 2008 Subscribers; 
and a SQL Server 2008 Publisher can have SQL Server 2000 Subscriber

Can somebody explain me what I'm doing wrong? I guess, upgrade a Distributor to sql 2008 should help, but it means additional expenses, I'd like to avoid that at this moment

Answer 1

0

I may be wrong, but I think that 2008 R2 is seen as another version which would make it fall outside the 2 version range.

answered Jan 04 '12 at 09:36 AM

Martin Schoombee
221 ● 2

Yep, 2008R2 is a version higher than 2008 and falls outside the 2 version boundary.

Jan 05 '12 at 12:07 AM WilliamD

@WilliamD Below hyperlink may be suggesting something else. AS it says the documentation is not changed since SQL 2008.

http://msdn.microsoft.com/en-us/library/ms143241.aspx

I do not have the environment to test it. So cannot be sure. But If the OP or yourself can test it (if not already), please let me know for the assurance. Thanks.

Jan 05 '12 at 01:07 AM Usman Butt

This link would sum it up better

http://technet.microsoft.com/en-us/library/ms143241.aspx

Jan 05 '12 at 01:14 AM Usman Butt

That may be, but 2008R2 is a different version to 2008. You cannot restore a 2008R2 backup on a 2008 instance.

As it stands I think that the 2008R2 subscriber will not be able to be added. The OP should stay at 2008 or upgrade the older instances to a newer one. SQL 2000 is out of support and over 10 years old.....

Jan 05 '12 at 01:36 AM WilliamD

Sorry guys, I'm cancelling my question. The problem is, I tried to add new Subscriber on the Distributor server using SSMS 2005, that's the reason of the error message. I did it successfully using SSMS 2008.

Jan 05 '12 at 07:44 AM pankovster

(comments are locked)

Answer 2

0

Are you trying to add the SQL Server 2008 subscriber from SQL Server 2005 SSMS? Try to add it from SQL Server 2008 box.

answered Jan 04 '12 at 11:43 PM

Usman Butt
13.8k ● 6 ● 8 ● 14

yes, this is what I was expecting as well. You do not have to cancel the question. It could help some other user coming here while searching. Moreover, it seems like my answer was correct, so if you feel that mark that as an accepted answer.

Jan 05 '12 at 07:57 AM Usman Butt

(comments are locked)

compatibility of publisher, subscriber and distributor

Follow this question

Related Questions