SP3 in a ‚mixed mode area’ with SP4

• dBaser

  SSC Rookie

  Points: 27

  More actions

  April 13, 2006 at 6:06 am

  #169040

   We have two central SQL 2000 server with SP3 (here called: server ‚A’ and server ‚B’; both with write databases) and some decentralized SQL servers (here called: server ‚Branches’; write and read database) likewise with SP3. Both servers (‚A’ and ‚B’) having replications to all decentralized SQL servers (‚Branches’).

  From ‚A’ to ‚Branches’ two transaction replications.

  Between ‚A’ and ‚ Branches’ some transaction and merge replications.

   

  Now we are planning to upgrade only Server ‚A’ with SP4. The write processe only occure on Server ‚A’. Our vendors (for Server ‚A’) reports no problems with the software.

  But they do not know what happens to the replication, system or other databases by the ‚Branches’.

   

  We have no experiences with such a ‚mixed mode’. Do you have?

   

  Questions:

  1. Generally: What must we do first? What must we consider? Problems to solve?

  2. Must we first delete the old replications? Which one (‚A’ and ‚B’)?

  3. May something happens to the other databases / replications / system?

  4. May there be problems with shared resources by the ‚branches’ (master or distribution)?

   

  Thanks.

• peterhe

  SSChampion

  Points: 11469

  More actions

  April 13, 2006 at 7:35 am

  #632366

  In the readme file (http://download.microsoft.com/download/1/B/D/1BDF5B78-584E-4DE0-B36F-C44E06B0D2A3/ReadmeSql2k32sp4.htm) of SQL 2000SP4, there is a section (3.5 and 3.6) that describes how to install SP4 on replicated database. Check 5.2 also, SP4 has some enhancement for replication.

  The readme has some errors whcih are corrected in http://support.microsoft.com/?kbid=884525. Check 3.5 in the page.

   

  However, the best answer is to set up a similar environemnt to test the upgrade.