December 30, 2014 at 8:30 am
Slightly off topic - sorry, but this is the only forum I use.
If I apply Widows patches to a SQL server during the day, but hold off on the final reboot until the next morning, is there any risk or downside to doing it that way ?
December 30, 2014 at 9:13 am
Just hope windows doesn't decide to reboot without prompting you.
December 30, 2014 at 9:32 am
Maybe.
We did not have direct control of our servers in our old data center. The windows admins would push patches at some point during the week, and re-boot on the weekends. We never knew when or what was pushed.
Sometimes there were no issues, sometimes there were issues.
Most of the time this worked properly. When it didn't, the proverbial do-do hit the fan.
If an issue was to be found, it was uncovered in the test and stage environments first.
I recommend that you read the KB articles and understand exactly what things will be affected by the patches prior to doing this, and if possible, use a testing environment first.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
December 30, 2014 at 9:38 am
No real danger. Some things take effect immediately in the patch, some don't until reboot. However no issue as long as (mentioned above) it isn't a patch that tries to reboot in 15 minutes, or presents a dialog someone clicks on.
December 30, 2014 at 10:15 am
Thanks for the replies. I log on to the servers under my own account, so there is a "Reboot Now" button, but I would be the only one to see it. No one else would be logging on to the servers except maybe IT manager in a vary rare situation, but under a different account.
I usually apply patches on low priority servers first, up to final prod server, which has a hot spare. I don't do live & hot spare at the same time. Usually a couple days in between.
December 31, 2014 at 12:19 pm
ideally reboot as soon as the patches are applied, holding off til the end of the day has never been too much of an issue for me though
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply