SQL Server Performance

Shut Down SQL Server involved in replication

Discussion in 'Performance Tuning for SQL Server Replication' started by Jon M, Sep 30, 2005.

  1. Jon M Member

    Hi All,
    We need to perform maintenance that requires all servers to be shut down.

    What is the proper way of shutting down SQL servers that are involved in transactional replication?

    I have this in mind, is this correct?
    1. Shutdown the subscriber
    2. Followed by the distribution server
    3. And then the publisher

    Then when starting up the servers i'll just do the reverse, is this right?
    1. Start the publisher
    2. Followed by the distribution
    3. And then the subscriber

    Thanks,
    Jon M
  2. satya Moderator

    Ensure no replication jobs are running at the time of SHUTDOWN, if not disable them until the SQL services come backup normally.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. satya Moderator

    Ensure no replication jobs are running at the time of SHUTDOWN, if not disable them until the SQL services come backup normally.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page