Looks like dozens of fixes for SQL Server 2008 have made their way into another cumulative rollup; CU3 for SP1 (build 2723), and CU6 for RTM (build 1812). You can get them here:
Cumulative Update 3 for SP1:
http://support.microsoft.com/kb/971491
Cumulative Update 6 for RTM:
http://support.microsoft.com/kb/971490
So what are the main differences? While I won't pretend (like I did last time) that some of the "missing" fixes from a build weren't already in there from a prior cumulative update, and I also won't pretend that I would be motivated in any way to painstakingly go and track them all down, there definitely seem to be some fixes that only made it into one of these builds, and only a handful that made it into both.
| KB Article | CU6 for RTM 10.00.1812 KB #971490 |
CU3 for SP1 10.00.2723 KB #971491 |
Both |
|---|---|---|---|
| KB #948567 | yes | – | – |
| KB #956574 | yes | – | – |
| KB #967315 | yes | – | – |
| KB #967522 | – | yes | – |
| KB #967552 | – | yes | – |
| KB #968722 | yes | – | – |
| KB #968740 | – | yes | – |
| KB #968741 | – | yes | – |
| KB #968742 | – | yes | – |
| KB #968834 | yes | – | – |
| KB #969050 | yes | yes | yes |
| KB #969357 | – | yes | – |
| KB #969467 | – | yes | – |
| KB #969528 | yes | yes | yes |
| KB #969611 | – | yes | – |
| KB #969793 | – | yes | – |
| KB #969844 | yes | yes | yes |
| KB #969997 | – | yes | – |
| KB #970014 | yes | – | – |
| KB #970044 | yes | – | – |
| KB #970058 | yes | yes | yes |
| KB #970133 | yes | – | – |
| KB #970150 | – | yes | – |
| KB #970160 | – | yes | – |
| KB #970198 | yes | – | – |
| KB #970287 | – | yes | – |
| KB #970399 | – | yes | – |
| KB #970507 | – | yes | – |
| KB #970538 | – | yes | – |
| KB #970551 | yes | yes | yes |
| KB #970666 | – | yes | – |
| KB #970713 | yes | yes | yes |
| KB #970823 | yes | yes | yes |
| KB #970909 | yes | yes | yes |
| KB #970966 | yes | yes | yes |
| KB #971049 | – | yes | – |
| KB #971051 | – | yes | – |
| KB #971057 | – | yes | – |
| KB #971064 | – | yes | – |
| KB #971068 | – | yes | – |
| KB #971132 | – | yes | – |
| KB #971136 | yes | yes | yes |
| KB #971402 | yes | yes | yes |
| KB #971640 | – | yes | – |
| KB #971772 | – | yes | – |
| KB #971780 | yes | – | – |
| KB #971914 | yes | – | – |
| KB #971985 | – | yes | – |
| KB #972068 | – | yes | – |
| KB #972197 | – | yes | – |
| KB #972198 | – | yes | – |
| KB #972200 | – | yes | – |
| KB #972201 | – | yes | – |
| KB #972203 | – | yes | – |
| KB #972207 | – | yes | – |
| KB #972261 | – | yes | – |
| KB #972440 | – | yes | – |
| KB #972521 | – | yes | – |
| KB #972650 | yes | – | – |
| KB #972681 | yes | yes | yes |
| KB #972759 | – | yes | – |
| KB #972763 | – | yes | – |
| KB #972767 | yes | yes | yes |
| KB #972777 | – | yes | – |
| KB #972984 | – | yes | – |
| KB #973200 | – | yes | – |
| KB #973204 | yes | – | – |
| KB #973250 | – | yes | – |
| KB #973257 | – | yes | – |
| KB #973301 | yes | yes | yes |
| KB #973302 | yes | – | – |
Cindy, you shouldn't need to blow away SQL Server 2008. You should be able to install SP1 on your current instance, then install CU3 for SP1. At worst case you will miss out on a couple of fixes that were in 1812 but not in 2723, so if you are actively relying on one of those fixes, you'll want to verify whether it is not in 2723 at all or if it was inserted in an earlier CU for SP1. That should be small if anything, and those fixes will usually return in the next CU.
Thanks for the quick reply Aaron. My team went thru the process of installing SP1 and then the cumulative update 3 for SP1. I did not go that route, and I wasn't sure how different my build is from theirs. Seems like the differences are huge, so I am going to blow away my SQL2008 and reinstall to get the same build.
Thanks again!
Cindy, you can't apply 2723 unless you first apply SP1, so there is no case where you can "skip" SP1 to get a later build. However you should note that the builds are nowhere near equivalent. In many cases a fix is introduced in one branch or the other (RTM vs. SP1) and only later (or sometimes never) ported to the other branch. These updates are no exception. I have updated the main body to show the 71 fixes that are shared between these two builds, and how most of them only seem to be in one build or the other (most seem to have targeted SP1; and those that are missing from there might already be there from a previous SP1 CU).
What is the diff between build 2723 and 1812… aside from skipping sp1 install along the way? Is there a benefit to using one build over the other?