Post reply

reboot sequence for publisher , distributor and subscriber

  • June 15, 2009 at 11:19 pm

    #138614

    Hi ,

    do we need to reboot the servers involved in replication in sequence like distributor first then publisher and then subscribers,what are the issues if they are not rebooted in sequence if any ?

    Thanks!!

  • June 22, 2009 at 12:22 pm

    #1013503

    In theory, it shouldn't matter what order you reboot.

    But, in practice, I find that if you reboot your publisher or subscriber while your distributor is still running, then you will get a flood of connection errors in the replication logs.

    I'm assuming you use transactional replication.

    So, I always disable my sql agent on the distributor, then I reboot the publisher and subscriber and then finally I reboot the distributor, which auto-restarts the sql agent service, which restarts the various jobs used for replication.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply