March 28, 2012 at 4:25 pm
We have transaction replication between two SQL Server 2005 Servers, the distributor currently running on the same instance as PROD box, to alleviate the load on PROD instance, we decide to use a dedicate box for distributor, question is : Can we use SQL Server 2008 R2 instead of SQL Server 2005 as distributor ? Thanks.
ddfg
March 28, 2012 at 4:43 pm
You should be ok with that.
http://msdn.microsoft.com/en-us/library/ms143241(v=sql.110).aspx
The referenced article describes a scenario of a distributor on 2008, transactional replication between a 2000 and 2005 box.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 28, 2012 at 5:04 pm
Thanks Jason, appreciated , this helps !
ddfg
March 28, 2012 at 5:11 pm
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply