SQL Server SP/Hotfixes

Question

Post reply

SQL Server SP/Hotfixes

NJDave

SSCommitted

Points: 1903
More actions
January 13, 2014 at 11:23 am

#396100

Hello - are there hotfixes for SQL Server? I can see at this link...
http://technet.microsoft.com/en-us/sqlserver/ff803383.aspx
there are service packs for each version, if I installed the latest service pack, is that it?
Sorry this seems like a dumb question - a coworker made me think there was more to it than just the latest service pack.
Thanks
Dave

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Tharg SSC Eights! Points: 980 More actions · Answer 1

The phrase here is "Cumulative Updates". See here.

So after each Service Pack for the relevant platform, install the latest CU and you're bang up to date.

NJDave SSCommitted Points: 1903 More actions · Answer 2

Thank you - that was the phrase I needed (cumulative updates)

I also see that some people have the opinion to wait for service packs

http://www.sqlservercentral.com/Forums/Topic1486749-391-1.aspx

http://ask.sqlservercentral.com/questions/7940/cumulative-updates.html

Thank you for answering my question.

Nadrek SSC-Insane Points: 20039 More actions · Answer 3

Also see sites like http://sqlserverbuilds.blogspot.com/[/url].

Note that opinions vary. My general go-to methodology is:

Apply all SP's a couple weeks after they come out (every once in awhile, they cause major problems) (Third party products may also warn if you keep up to date, or even break in rare cases).

Read CU notes to see if they apply to you - if they do, apply them. If not, don't, unless there's a later security update.

Apply the QFE (CU) form of all security updates (i.e. when there's a security patch for SP2, apply the latest CU and then apply the QFE version of the security update).

Steve Jones - SSC Editor SSC Guru Points: 736188 More actions · Answer 4

We have build lists here as well: http://www.sqlservercentral.com/articles/Build+List/71065/