question

pankovster avatar image
pankovster asked

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
sql-server-2008sql-server-2005sql-server-2000replication
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Martin Schoombee avatar image
Martin Schoombee answered
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.
6 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image WilliamD commented ·
Yep, 2008R2 is a version higher than 2008 and falls outside the 2 version boundary.
1 Like 1 ·
pankovster avatar image pankovster commented ·
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.
1 Like 1 ·
Usman Butt avatar image Usman Butt commented ·
@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.
0 Likes 0 ·
Usman Butt avatar image Usman Butt commented ·
0 Likes 0 ·
WilliamD avatar image WilliamD commented ·
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.....
0 Likes 0 ·
Show more comments
Usman Butt avatar image
Usman Butt answered
Are you trying to add the SQL Server 2008 subscriber from SQL Server 2005 SSMS? Try to add it from SQL Server 2008 box.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Usman Butt avatar image Usman Butt commented ·
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.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.