question

Aa-2020 avatar image
Aa-2020 asked

Restarting Sql server with replication running on it

hi guys , I need to restart Sql server with replication running on it, is it safe enough to stop the log reader and snapshot reader , then stop and restart the server

replication
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
JohnM avatar image
JohnM answered

You should be able to just restart the instance. The readers will just pick up where they left off when the instance comes back up. They are resislent to a restart of the instance.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.