compatibility of publisher, subscriber and distributor

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

more ▼

asked Jan 04, 2012 at 09:11 AM in Default

avatar image

1 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.

more ▼

answered Jan 04, 2012 at 09:36 AM

avatar image

Martin Schoombee
611 4 4

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

Jan 05, 2012 at 12:07 AM WilliamD

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


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, 2012 at 01:07 AM Usman Butt
Jan 05, 2012 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, 2012 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, 2012 at 07:44 AM pankovster
(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Jan 04, 2012 at 11:43 PM

avatar image

Usman Butt
14.6k 6 13 21

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, 2012 at 07:57 AM Usman Butt
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jan 04, 2012 at 09:11 AM

Seen: 3624 times

Last Updated: Jan 05, 2012 at 02:53 AM

Copyright 2018 Redgate Software. Privacy Policy