September 15, 2011 at 10:59 am
Anybody know if we can setup transaction replication from sql server 2008 R2 back to sql server 2005 ? Any issues ? Thanks.
ddfg
September 15, 2011 at 11:10 am
I have a very large replication system, using 2008 as my distributor and replicating to 2K as well as 2K5 subscribers without any issues. The issue arises when you use a publisher of a lesser version. The issue there is that you are limited then in the distributor to the capabilities of the lowest version of the publisher ie: if you have a SS2K publisher, you will need to run some SP's against your distributor and the capabilities of the distributor will be limited to be equal to that of SS2K
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
September 15, 2011 at 1:09 pm
thanks Steve, is there any benefit for performance to put distribution database on seperate instance instead of production instance ?
ddfg
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply