I have a Dell r610 server with Windows 2008 R2 Enterprise as a host with Hyper-V installed with four virtual machines (VM) each running Windows 2008 R2 Enterprise, one VM also has MS SQL Server 2008 R2.
I have the VM's apply Windows Updates automatically on Sundays at 12am, I am also applying updates on SQL Server at same time as OS on the one VM with SQL Server on it.
However I want to automate the updates on the Host Machine.
Is it possible to automate this on host?
What does the host do with the VM's when it needs to reboot? Does it gracefully shutdown the VM's?
Is there another approach to automatically patching the host machine?
Any special requirements needed with the VM that has SQL Server 2008 R2 on it?
I am considering to do Host patching at 3am on Sundays, is it a good practice, should the host get patched first then VM's or does it matter?