October 12, 2018 at 4:01 pm
What would be the best practice and steps need to follow if ever need to restart the sql server, when the server is configured as Mirroring and replication?
Thanks
October 14, 2018 at 2:06 pm
Assuming everything is set up and functioning normally, you should be able to re-start the primary or secondary without issue.
What are you expecting to happen, or worried about happening?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
October 14, 2018 at 3:29 pm
Admingod - Friday, October 12, 2018 4:01 PMWhat would be the best practice and steps need to follow if ever need to restart the sql server, when the server is configured as Mirroring and replication?Thanks
If you restart the primary it will switch over to the secondary.
If you want to restart both servers (for example during patching) and leave them with the same primary and secondary you should restart the primary, then restart the secondary.
October 15, 2018 at 11:40 am
Jonathan AC Roberts - Sunday, October 14, 2018 3:29 PMAdmingod - Friday, October 12, 2018 4:01 PMWhat would be the best practice and steps need to follow if ever need to restart the sql server, when the server is configured as Mirroring and replication?Thanks
If you restart the primary it will switch over to the secondary.
If you want to restart both servers (for example during patching) and leave them with the same primary and secondary you should restart the primary, then restart the secondary.
Instead of relying on automatic failover based on server outage - I recommend:
1) Patch secondary server - restart server
2) Manually failover to the secondary server - verify system is working as expected
3) Patch primary server - restart server
4) Manually failover to the primary server
The second step is very important - it insures that your system is not adversely affected by the patch and provides a fall back if there are issues.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply