Reinstall Service Packs with added features?

  • Back in the last century when I began my IT career, I was taught that after installing an optional component to MS SQL (or Windows) which was not selected during the inital install, it was necessary to reinstall any service packs which had been previously installed to ensure that the the new feature was at the same patch level as the rest of the installation.

    I don't recall seeing any instuction of this step anytime recently. Is there logic built into the Setup applications that automatically updates added components to the appropriate patch level?

  • No, enabling/disabling any installation features does not need a service pack reinstall these days, thankfully that all went out of the window with NT, that had very specific processes for adding new features to windows which don't matter any more. However, the only caveat with that is if you were to enable Analysis Services for instance, a few updates may be available via Windows Update/WSUS that are specific to that feature, so you many need those, but you don't need to do a service pack reinstall.

    The simplest way to test would be to do this on a standalone instance, and just check Windows Update/WSUS afterwards and see if anything new is available.

Viewing 2 posts - 1 through 1 (of 1 total)

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