Urgent: Installing SP4 on Server with REPL

  • Hi,

    I have a sql server 2000 having replication to other 4 sql server 2000. All these sql servers are having SP1 installed. Now i am planning to install SP4 on the publication server. My question is is it safe to installe SP4 on one server? Will it affect my replication anyway?

    Pls. guide asap.

  • i'm sure I remember someone posting that you want to upgrade the receiver(s) of the replication prior to upgrading the publisher.  other than that I do not remember any issues.

     

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • I believe it's distributor, publisher, subscriber order.

  • thanks for the correction Steve; i never get to play with replication, but I try to read about it here.

     

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • hey guys,

    do you think there could be any issues related to replcation or something else if i upgrade my primary server with SP4.??

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply