Friday, April 16, 2010

Cumulative Update 7 for SQL Server 2008. Be aware, there are TWO versions of CU#7…

Bumped into this issue at a customers site. An update of SQL Server 2008 SP1 was needed.

They wanted to apply the latest CU which is CU#7. So they downloaded it, unpacked it an ran it on the SQL Server. This is what the update told them:
image

? ‘A SQL Server patch with a higher version has already been installed…’ ?

Time for some investigation. Soon the cause was found.

There are two versions of CU#7 for SQL Server 2008. One for SQL Server 2008 WITHOUT SP1 (KB973601) applied and another version for SQL Server 2008 WITH SP1 applied (KB979065).

So when the correct CU#7 was downloaded:
image 

and ran on the SQL Server, this was shown:
image

And now CU#7 applied just fine.

So when CU#7 needs to be installed, make sure to download the correct version.

No comments: