Replication server restart

kK-2020 46

I wanna restart a Sql server running on a vm which host replication on it, is it safe to just stop the log and snapshot reader and restart the server or do I also have to disable the publisher and distributor

1 answer

Leon Laude 85,691 Reputation points

2020-07-04T08:49:57.093+00:00
Hi,

Should be safe to stop both snapshot and log reader agents.

Start and Stop a Replication Agent (SQL Server Management Studio)
https://learn.microsoft.com/en-us/sql/relational-databases/replication/agents/start-and-stop-a-replication-agent-sql-server-management-studio?view=sql-server-ver15

Then as long as you don't have any long running transactions you can restart the SQL Server using the console or shutdown command during a low activity period or during a maintenance window.

A clean shutdown of an SQL Server occurs in below scenarios :

Stop SQL server using services console.

Shutting down your server

Running "SHUTDOWN" command in SSMS

Best regards,
Leon
Please sign in to rate this answer.
kK-2020 46 Reputation points

2020-07-04T08:55:27.783+00:00

Thanks Leon for your response
Just bear in mind that there is replication running on this instance publisher but distributor and subscriber on a different server.
Is it just enough to stop log reader and snapshot reader and log reader agent from replication node and no need to disable the publisher or distributor and once the log reader is stopped it’s safe to go ahead and stop the instance without breaking the replication.
And then start the server back up and turning the log reader back on, please confirm

Leon Laude 85,691 Reputation points

2020-07-04T08:57:10.327+00:00

You do not actually need to stop the agents prior to stopping the services, the replication will pick up where it left off.
If you wish to stop the agents prior to stopping the services then of course you can; stop the Log Reader Agent then the Distribution Agent.

kK-2020 46 Reputation points

2020-07-04T09:00:17.52+00:00

Thanks Leon
But definitely no need to disable the distributor and publisher from replication node just the log reader agent should be sufficient ?

Leon Laude 85,691 Reputation points

2020-07-04T09:01:27.337+00:00

That should be sufficient yes.

kK-2020 46 Reputation points

2020-07-04T09:04:07.8+00:00

Cos I couldn’t find the distributor agent, all I was able to find is the log reader agent and snapshot agent , but like you said if the log reader is sufficient then that should be fine with

Leon Laude 85,691 Reputation points

2020-07-04T09:08:21.383+00:00

Yes it's fine if you don't have a distributor agent :-)

(Please don't forget to accept helpful replies as answer)

kK-2020 46 Reputation points

2020-07-04T09:10:15.947+00:00

The distributor agent is on another server in that cass just the log reader wich is on the machine I’m restarting should be sufficient.?

Leon Laude 85,691 Reputation points

2020-07-04T09:12:32.203+00:00

If it's on another server, then you don't have to worry about the distributor service.
Sign in to comment

Share via

Replication server restart

1 answer