Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Reinstall Service Packs with added features?


Reinstall Service Packs with added features?

Author
Message
dan-572483
dan-572483
SSChasing Mays
SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)SSChasing Mays (643 reputation)

Group: General Forum Members
Points: 643 Visits: 1958
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?
liteswitch
liteswitch
SSC Journeyman
SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)SSC Journeyman (86 reputation)

Group: General Forum Members
Points: 86 Visits: 598
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search