Upgrading a SQL Replication Topology

Jonathan Allen wrote to me asking what order one should upgrade servers in a replication topology – pointing out that this doesn’t seem obviouis from Books On Line, which I agree.

The answer is essentially the same as for any previous upgrade:  Distributor first (as it has to handle new and old log record formats), then the Publisher and finally the Subscribers.

Comments (2)

  1. Kevin Remde says:

    I just posted about this today as well. (http://blogs.technet.com/kevinremde/archive/2005/08/23/SQLTidbit004.aspx)

    My understanding, though is that as long as you have done the distributor, it really doesn’t matter which ones you do next. Publishers and Subscribers can be either 2000 or 2005.

  2. Mat_stephen says:

    Hi Kevin

    I’m sure you’re correct – I was taking a ‘safe’ steer from SQL 2000 BOL (mk:@MSITStore:C:Program%20FilesMicrosoft%20SQL%20Server80ToolsBooksinstsql.chm::/in_upgrade_45ir.htm)which does give this order but does make exception – and a colleague with a priori knowledge