dpbakerdpbaker avatar image
dpbakerdpbaker asked

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
service pack
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.