SQL 2000 - Service Pack 2 - Installation order?

SQL 2000 - Service Pack 2 - Installation order?

Post by Matthia » Thu, 14 Feb 2002 17:52:27

We use SQL Server 2000 SP1 on our server and MSDE 2000 SP1 on our
notebook-clients, which use pull merge replication over WAN.

Now I want apply SP2 to server and clients. I can't update all machines at
once because clients are all over the world - so it will take some weeks
until all machines are updated.

Question: What's the best installation order? Update the server to SP2 and
then the clients or update first all clients and then the server. Can SP1
replicate with SP2 without problems?



SQL 2000 - Service Pack 2 - Installation order?

Post by Xiaoyu Li [M » Fri, 15 Feb 2002 04:29:13

Please upgrade the SQL replication distributor first, publisher secondly,
and the subscribers last.

Xiaoyu Li
Microsoft SQL Server Support

This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure?  For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit


1. Service pack installation order question

I have a W2K (with W2K SP2)Advanced Server MSCS cluster
with Enterprise Edition SQL 2000 installed on it.  I am
planning on installing W2K SP3 and SQL 2000 SP2.

Does the order of installation matter?  Is there any
circumstance that I would have to reinstall either of the
service packs (like you had to with NT 4 when you add new
hardware)?  Thanks in advance.

2. own error message

3. Service Pack installation orders

4. Clever pivot

5. Service pack 2 for sql server 2000 on windows 2000 server

6. Windows 2000

7. Fwd: SQL Server 2000 and MSDE 2000 Service Pack 3a Released

8. California - Oracle Financials/Manufacturing Developer

9. SQL Service pack 2 installation problems

10. SQL Server 2000 Personal Edition/Service Pack 3

11. SQL Server 2000 Service Pack 3 Available

12. service pack - sql 2000