Stop replication temporarily because of maintenance

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wingman - 27 Dec 2005 16:57 GMT

We are using transaction push replication and like to shut down the
subscriber server for some maintenance maybe 3~4 hours. What is the best
way to shut down the replication or do I even need to worry about it?

I am thinking about stopping the distribution agent or maybe logreader agent
in SQL ME.

Please advise.

Wing

Reply to this Message

Hilary Cotter - 27 Dec 2005 19:00 GMT

Stopping the distribution agent is the best approach to a problem like this.

Signature

Hilary Cotter
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

> We are using transaction push replication and like to shut down the
> subscriber server for some maintenance maybe 3~4 hours. What is the best
[quoted text clipped - 7 lines]
>
> Wing

Reply to this Message