Poll: SQL Server Builds...
-
I thought I would throw a question out to the community as it appears (to me) that Microsoft has changed how we obtain hotfixes and service packs.
Do you:
1) Install build upgrades whether your system needs them or not (just want to have the latest)?
2) Do as Microsoft advise and leave the build at service pack level and then install build upgrades only when you experience a problem and one of them happens to match the issue?
3) Build upgrade? Service Pack? I quit!!
My preference is for #1 but I'm interested in knowing what others do at their sites.
Thanks to all who respond....
A lack of planning on your part does not constitute an emergency on mine.
-
Personally I do something like #2... only after testing. And allowing the rest of the community to sniff out the problems first. Unless there's some sort of critical security issue coming down the pike, I usually don't pay attention to service packs for a month or so after their release. Then see what problems others are having. Then I throw it on a test box to make sure it won't break anything in our environment.
If it's an emergency security issue then I'd truncate my timetable a bit.
Also I check with my application vendors as sometimes they're not supporting the newest service pack or patch yet. I've seen support contracts where you're only covered if you've applied only approved patches to the machine. Would suck to pay for high-level application support and then not be able to exercise it...
-
I agree with Aaron move to the latest service pack and then apply build if and when necessary.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
That makes sense....
Have the build sitting there and being familiar with the fix if you happen to see the problem. Otherwise have it tested and ready to go - but not installed.
That course of action tends to indicate that people do *not* hold great faith in Microsoft to get the fix right the first time and that is unfortunate
A lack of planning on your part does not constitute an emergency on mine.
-
Its not that we don't faith MS but there might be issues that arise when the build is not needed. So better to check and deploy the build as and when necessary.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply