x

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

pankovster gravatar image

pankovster
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

Martin Schoombee gravatar image

Martin Schoombee
221 2

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.

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

Usman Butt gravatar image

Usman Butt
13.9k 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, 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1951
x1850
x476
x306

asked: Jan 04, 2012 at 09:11 AM

Seen: 2239 times

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