x

Can upgrading shared features cause problems with other SQL Server instance not up to latest Sevice Pack

We have a SQL2012 Clustered Server with multiple 2012 instances in a Active/Active/Passive Cluster. With this environment how do I apply the latest service pack in SQL 2012. We only want to do it on one of our instances and I don’t know what affect upgrading the shared services feature will have on the other instances of SQL that are not receiving the SP. So before applying, I want to make sure I understand the impacts of doing so and couldn’t find anything online that specifically explains this to me. Since the installer allows you to check which SQL instance you are applying to patch to, that is a good thing, however there is no way to exclude the shared features selection. One of the shared features is the ETL tool SSIS(Integration Services). It’s automatically upgraded to the latest SP locally on that server during the upgrade. My question is, what are the effects of this? One, example is modifying Maintenance Plans, this is using the SSIS tool and one of the questions I have is will it force me to upgrade any SSIS package (on the server) once the SP3 is applied? Or since this is not a major version upgrade (Ex SQL20008R2 to SQL2012, maybe it won’t have an issue with it(having a higher service pack). I do not want to get into the situation where I’ve upgraded one instance but since I’ve upgraded the shared features locally on the server, I’m faced with having to upgrade all of the instances. Also are there any negative effects from jumping from Service Pack 1 to Service Pack 3 CUM 5(the latest available).

Thanks

more ▼

asked May 19 at 08:02 AM in Default

avatar image

dpbakerdpbaker
1

(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x5

asked: May 19 at 08:02 AM

Seen: 50 times

Last Updated: May 19 at 08:02 AM

Copyright 2017 Redgate Software. Privacy Policy