"José Araujo" <jiaf@cantv.net> wrote in message
news:eo5v4vinHHA.3704@TK2MSFTNGP02.phx.gbl...
> Hi everyone,
>
> In the SQL2005 SP2 readme file says that to install in a replication
> topology (merge) it has to be done in the following order:
> 1.. Distributor
> 2.. Publisher
> 3.. Subscribers
> I have a single server acting as publisher/distributor and around 19
> subscribers (merge replication - everything SQL2005 SP1 Standard Edition).
>
> I would assume I can install the service pack in my publisher/distributor
> and resume replication.
>
> Then, gradually, over a few days I can install the service pack in the
> subscribers (one by one). While doing that I intend to keep replication
> going.
>
> Is that supposed to work? Has somebody tested it?
>
> Thanks for the feedback, José Araujo.
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:uNBtr$inHHA.1244@TK2MSFTNGP04.phx.gbl...
> That's the way it works for us.
>
> "José Araujo" <jiaf@cantv.net> wrote in message
> news:eo5v4vinHHA.3704@TK2MSFTNGP02.phx.gbl...
>> Hi everyone,
>>
>> In the SQL2005 SP2 readme file says that to install in a replication
>> topology (merge) it has to be done in the following order:
>> 1.. Distributor
>> 2.. Publisher
>> 3.. Subscribers
>> I have a single server acting as publisher/distributor and around 19
>> subscribers (merge replication - everything SQL2005 SP1 Standard
>> Edition).
>>
>> I would assume I can install the service pack in my publisher/distributor
>> and resume replication.
>>
>> Then, gradually, over a few days I can install the service pack in the
>> subscribers (one by one). While doing that I intend to keep replication
>> going.
>>
>> Is that supposed to work? Has somebody tested it?
>>
>> Thanks for the feedback, José Araujo.
>>
>
>