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
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.
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.
@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.
This link would sum it up better
http://technet.microsoft.com/en-us/library/ms143241.aspx
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.....
Are you trying to add the SQL Server 2008 subscriber from SQL Server 2005 SSMS? Try to add it from SQL Server 2008 box.
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.
