Showing posts with label principal. Show all posts
Showing posts with label principal. Show all posts

Monday, March 12, 2012

Rebooting Mirrored Servers

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.