8

I just installed all possible Windows updates on WS2008R2/SQL2012 instance. When I run

SELECT @@VERSION

I get

Microsoft SQL Server 2012 - 11.0.5058.0 (X64) 
    May 14 2014 18:34:29 
    Copyright (c) Microsoft Corporation
    Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)

According to

http://sqlserverbuilds.blogspot.com/

and Microsoft websites, there are 4 Cumulative Updates available for SQL Server 2012 SP2 and the newest build is 11.00.9000.

Why didn't Windows Update get Cumulative Updates too? Should I download and install them manually?

  • You are saying you have installed windows update ? How its related to SQL Server. Did you installed SQL update via windows update facility. Plus what update you installed which CU can you be specific. – Shanky Feb 7 '15 at 18:30
  • I ran Windows Update for both the OS and other Microsoft products (including SQL Server 2012). I installed SP2 and a few extra updates for SQL that were available. I did not install any CUs manually. I didn't even know they were there. – BuahahaXD Feb 7 '15 at 18:33
  • you need to download them manually ;) – Kuba Miazek Feb 9 '15 at 14:21
10

Windows Update will only tell you about service packs for SQL Server, and only when you've enabled the "update other Microsoft products too" option (sorry, the wording has changed across versions, and I don't recall all of the variations).

SQL Server service packs are recommended primarily because the RTM branch (and earlier service pack branches) are ultimately retired and placed out of support. They are also supposedly more reliable and better tested than cumulative updates. I don't know that they should be provided via Windows Update, though, because that just makes it possible for a service pack to be deployed automatically. I don't like that idea at all - and I don't get a warm and fuzzy about how often I have to disable the "force feed me updates" setting and change it to a more appropriate "download them and tell me about them" option.

Cumulative updates, on the other hand, are recommended by some of us (Glenn Berry and I are vocal proponents of keeping up with CUs, because generally we've found them to be just as solid as service packs - though recently there have been a few chinks in that armor). But the message from Microsoft is not so clear. While they do put the updates out and publicize them, each one of them has this text (this is taken from 2012 SP2 CU4):

We recommend that you apply The most recent update release.

The link points to KB 2983249, which gives you links to all of the cumulative updates for that branch. But then, in the CU article, the very next piece of text is:

This cumulative package is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems.

This disclaimer is probably the reason you won't see cumulative updates being pushed through Windows Update. I know they've been working on bolstering the regression testing and therefore the stability that you can expect from cumulative updates, but until that disclaimer disappears, you're going to continue to have to seek out cumulative updates on your own. I try to keep people updated on all updates (service packs, cumulative updates, and out-of-band on-demand hotfixes) for SQL Server 2012 and SQL Server 2014, with some qualitative advice thrown in where appropriate:

From those two posts, you can probably guess that if people had received the most recent cumulative updates automatically, through Windows Update, they would be plenty upset, and justifiably so. I'm all for deploying cumulative updates but this rash of problems has made me adjust my timeline for doing so - like add a month, maybe, so that other people can shake these issues out and I stop being the guinea pig.

  • ♦, Clear & specific point of answer of SQL Server cumulative updates. For +1 – Md Haidar Ali Khan Oct 8 '17 at 11:52
2

You just installed few updates for windows I don't think any update which actually made change to SQL Server version was installed.

Current SQL Server version is Microsoft SQL Server 2012 - 11.0.5058.0 (X64) which says its still SP2.

Please don't install any SQL Server update via windows update feature it does not always functions correctly. If you want to install CU please download it and run the executable with admin privieges

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.