I need to apply SP2 on two SQL 2000 servers which have databases affected by transactional replication. Currently, I have no knowledge of SQL server replication and I do not know much about how it has been set up other than one server acts as the publisher and the other as the subscriber.
My question is, prior to applying SP2, are there any steps which are required in terms of setting, unsetting replication options etc. In other words, do I just go ahead and install SP2 and replication will continue to work or does replication have to be stopped, started, parameters changed etc. ? Does the server acting as the publisher have to be done first, or does the subscriber have to be done first or does it not matter?
Apologies for the broad range of questions, I am trying to get an idea on what if anything is required.