New to SQL. Can you reboot the principal server after running updates without causing a failover?
If not what would the correct procedure be.
Do you have a witness?
If so, you could stop SQL Server on the mirror while you reboot the principal, that will prevent failover.
When I do this I let failover happen - it's a good test of it and it's pretty quick, once the principal is back up you can fail back over to it.
|||If there is no witness , Database Mirroring will get into disconnected state and resumes when able to communicate with Mirror.
No comments:
Post a Comment