Quiescing Replication

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sandra - 27 Feb 2006 16:15 GMT

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!

Reply to this Message

Hilary Cotter - 27 Feb 2006 16:26 GMT

It means boot all your users off the box.

Signature

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

>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
[quoted text clipped - 5 lines]
>
> Thanks!

Reply to this Message

Paul Ibison - 27 Feb 2006 17:11 GMT

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)

Reply to this Message