Quiescing Replication

I need to install a service pack on replicated servers. Server A replicates
to Server B and vice versa. From what I understand (but correct me if I'm
wrong), I'll need to "Quiesce" the servers and install the service packs
simultaneously. But what does that mean. I looked at a KB article, but
didn't really understand when it said stop all activity on published tables.
Does that mean the agent jobs? or does that mean to make sure noone
accesses the database from the application?
Thanks!
It means boot all your users off the box.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Sandra" <skong@.ap.org> wrote in message
news:OpfU9j7OGHA.740@.TK2MSFTNGP12.phx.gbl...
>I need to install a service pack on replicated servers. Server A
>replicates to Server B and vice versa. From what I understand (but correct
>me if I'm wrong), I'll need to "Quiesce" the servers and install the
>service packs simultaneously. But what does that mean. I looked at a KB
>article, but didn't really understand when it said stop all activity on
>published tables. Does that mean the agent jobs? or does that mean to make
>sure noone accesses the database from the application?
> Thanks!
>
|||Sandra,
you can use this type of statement to get the databases into a correct
state:
alter database mydb set single_user with rollback immediate.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)