Some SQL Server updates have happened outside the maintenance window, which have caused the server to be rebooted. How can I stop this from happening again in future?
Below is what I can see when looking at the Windows Update Settings:
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
To prevent SQL Server updates to be installed automatically, you need to:
Important: choose "Manual", NOT "DownloadOnly", because even with "DownloadOnly" setting, some Windows Updates that Microsoft considers very important, may be still installed and machine will be rebooted (I've experienced it myself)
This way you have total control over when and how to install Windows and SQL Server updates