This question is about any recent version of MS SQL, but specifically this applies to SQL 2008 R2 in case that makes any difference.
We have two mirrored MS SQL servers and witness server. There are a lot of databases on the servers.
When it's time to reboot one server for Windows updates, do you have to first (manually or via a script) fail-over all the databases to the other partner? Or can you just reboot the SQL server (which will cause a failover)
I did find a script here but i don't know if it's necessary to use one when you do want to reboot or not:
If you do recommend scripting failover before rebooting, does the above script seem like the best option or can you recommend something better?