Monday, March 12, 2012

How to Reboot a Publication server ?

We have to add some hardware and I was wondering if someone could provide a stepwise tip to do it .

It is a 3 Server Environment Pub/Dist/Sub
All three running under SQL2K
Here is what I am planning.

a. Uncheck the Enable in Distributed Agent for each replication
b. Wait for all replications to complete
c. Shut down Publisher ? Or do I have to do something else before that.

Please explain a little .

ThanksStop Distribution Agent, make CHECKPOINT on Publisher and shut it down. You also could just shut down publisher but it is not a good practise.|||Thanks . I guess I don't have to worry about Log reader agents ! They will die once publisher is out ?

No comments:

Post a Comment