Identify Cumulative Updates applied to SQL Server 2005 SP3

Question

Post reply

Identify Cumulative Updates applied to SQL Server 2005 SP3

Welsh Corgi

SSC Guru

Points: 116520
More actions
January 12, 2012 at 10:45 am

#253440

I'm moving a Database Server to a new Machine.
The machine has SQL Server 2005 SP3 Standard Edition
They do not want to go to a new SP
The product version is 9.00.4262.00 which is between the following:
SQL Server 2005 Service Pack 39.00.4035
SQL Server 2005 Service Pack 49.00.5000.00
How do I identify which cumulative update that I need to install so that the new machine is at the same version?
Any help would be greatly appreciated.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Product version ReleaseEdition
9.00.4262.00SP3Standard Edition
SELECT @@version
Microsoft SQL Server 2005 - 9.00.4262.00 (Intel X86) Aug 13 2009 17:08:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

george sibbald SSC Guru Points: 104210 More actions · Answer 1

well, simple ways

see what patches you have in add\remove programs

do a search on 'build list' in the search field at the top right of the SSC page, and check out Steve's very useful info!

---------------------------------------------------------------------

Richard Moore-400646 SSCrazy Points: 2384 More actions · Answer 2

On this site - lists the build lists:

http://www.sqlservercentral.com/articles/Administration/2960/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

Thanks.:-) the KB Article is a Security patch, I assume that would I also need to apply the Cumulative Update that precedes the Security Patch?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Richard Moore-400646 SSCrazy Points: 2384 More actions · Answer 4

I'd apply, SP3, CU5, then the specific security patch that you have noted. I'm not sure if the add/remove programs shows the CUs or not - you could check there. But SP3 + the security patch would bring you to the same release level. You would have to know what was actually installed to get you to that point.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

Richard Moore-400646 (1/12/2012)
I'd apply, SP3, CU5, then the specific security patch that you have noted. I'm not sure if the add/remove programs shows the CUs or not - you could check there. But SP3 + the security patch would bring you to the same release level. You would have to know what was actually installed to get you to that point.

Thanks.

I had checked add/remove program before I posted this thread and it did not show any CU's.

So you think that this is the safest way to go and less risky?

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 6

That was a good article by Steve. Thanks!

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

george sibbald SSC Guru Points: 104210 More actions · Answer 7

did you have the updates box ticked when you checked, it should show all patches applied

---------------------------------------------------------------------

Richard Moore-400646 SSCrazy Points: 2384 More actions · Answer 8

Another thought I had was to look at the 'setup bootstrap\log' directory to see what history is out there. I believe the history is maintained, but I don't recall for sure. If you asking for my opinion - I'd install the CU and the security patch.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 9

george sibbald (1/12/2012)
did you have the updates box ticked when you checked, it should show all patches applied

I don't recall checking that box. I just left work, I will check in the morning thanks!

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 10

Richard Moore-400646 (1/12/2012)
Another thought I had was to look at the 'setup bootstrap\log' directory to see what history is out there. I believe the history is maintained, but I don't recall for sure. If you asking for my opinion - I'd install the CU and the security patch.

Thanks!

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 11

I got the go ahead to install SP4.

Should I install the following fix?

http://support.microsoft.com/kb/2494123

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

george sibbald SSC Guru Points: 104210 More actions · Answer 12

Definitely. But if you are applying directly after SP4 apply the GDR version - 2494120

---------------------------------------------------------------------

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 13

george sibbald (1/13/2012)
Definitely. But if you are applying directly after SP4 apply the GDR version - 2494120

The GDR version - 2494120?:unsure:

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

george sibbald SSC Guru Points: 104210 More actions · Answer 14

see the FAQ here

which version of the security patch you apply depends on the version of SQL you are patched up to - you want the GDR, not the QFE

---------------------------------------------------------------------