Shut Down SQL Server involved in replication | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Shut Down SQL Server involved in replication

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
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.
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.
]]>