Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    KY
    Posts
    146

    Unanswered: 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 .

    Thanks

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Stop Distribution Agent, make CHECKPOINT on Publisher and shut it down. You also could just shut down publisher but it is not a good practise.

  3. #3
    Join Date
    Sep 2003
    Location
    KY
    Posts
    146

    Thanks

    Thanks . I guess I don't have to worry about Log reader agents ! They will die once publisher is out ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •