x

SQL Server 2012 Upgrade with CU patch

The current version is SQL server 2012 SP2 (build 5058) and now there are few Hotfix and CU available to update the SQL server so I just want to know if I can install CU3 (build 5556) patch directly without installing CU1 and CU2 or all these needs to install sequentially one by one. The patch which I want to install is Hotfix for SQL2012 (build -5522) , CU1 (Build- 5532), CU2 (Build- 5548) and CU3 (Build- 5556). Please advise..

more ▼

asked Apr 20, 2015 at 06:52 PM in Default

avatar image

Sharma
1.4k 90 93 96

If you are using 2012 with Availability Group then I would look at updating to CU5 (if possible). There are a few other bug that have been resolved in this CU. As always, test first.

http://blogs.sqlsentry.com/team-posts/latest-builds-sql-server-2012/

Apr 21, 2015 at 08:42 AM sp_lock
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

A cumulative update (CU) contains all of the updates prior. If you install CU3, you'll get the updates from CU2 & CU1. You won't need to install them one by one.

A Hotfix is a specific update that addresses a specific issue. Is there a specific hotfix you are looking at?

Hope that helps!

more ▼

answered Apr 20, 2015 at 07:14 PM

avatar image

JohnM
14.1k 3 7 14

Could you also let me know the service pack update procedure on cluster and standalone node?

Apr 21, 2015 at 04:42 PM Sharma

Sure, on a cluster you would install the service pack on the inactive node and then during an appropriate maintenance window, fail over the active node onto the newly patched inactive node. Once the fail over is complete, you would patch the remaining node. Standalone, just install it. It will take the sql service offline so you'll need to plan an outage appropriately. Hope that helps!

Apr 22, 2015 at 12:14 PM JohnM
(comments are locked)
10|1200 characters needed characters left
Your answer
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:

x112
x88
x4
x2

asked: Apr 20, 2015 at 06:52 PM

Seen: 64 times

Last Updated: Apr 22, 2015 at 12:14 PM

Copyright 2017 Redgate Software. Privacy Policy