August 2, 2008 at 8:38 pm
Hi Folks,
I trying to work out how I stay ahead of the game when it comes to patching sql server. A website that has the latest patch level would be good and some sort of notification service. Can anyone help here?
August 3, 2008 at 9:58 am
We have one here: http://www.sqlservercentral.com/articles/Administration/2960/
SQL Server releases a Cumulative Update every other month and we usually announce it here when they do. Service Packs are supposed to come one a year moving forward.
August 4, 2008 at 6:47 pm
Two questions
what the current patch level for sql server?
Can I patch 1 instance without effecting another instance - e.g. SP2 is saying SQL Browser is locked. I will need to stop it. Does this effect all instances?
August 4, 2008 at 10:19 pm
Current official level is SP2. There are 8 cumulative updates so far. I know people are happy with 6, not sure about 7 and 8. Depends on what you're running. honestly if you don't have issues addressed in CUs, I'm not sure I recommend applying them.
Some things can be patched independently, some can't. Depends if they are instance aware. So SSIS is installed once for all instances on the server. If you patch it, it's patched for all instances.
http://msdn.microsoft.com/en-us/library/ms143504(SQL.100).aspx
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply