Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Reinstall Service Packs with added features? Expand / Collapse
Author
Message
Posted Tuesday, October 29, 2013 9:20 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 10:51 AM
Points: 558, Visits: 1,652
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?

Post #1509417
Posted Tuesday, October 29, 2013 9:59 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, December 5, 2014 9:03 AM
Points: 74, Visits: 567
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.
Post #1509445
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse