SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


History of Patches


History of Patches

Author
Message
arussell_10
arussell_10
SSC-Enthusiastic
SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)

Group: General Forum Members
Points: 168 Visits: 1326
All,

I just started at a new company and need a way to determine which patches have been installed on a server. My dev box and Production cluster are not patched the same (details below). I want to at least get Production to match Dev.

1) Is there a way to tell if any other CUs or Patches were applied to Dev in between the Security Update and SP3?
2) Can I just apply SP3 and the Security update to production?

Development
ProductVersion ProductLevel Edition EngineEdition
9.00.4053.00 SP3 Enterprise Edition (64-bit) 3 --- includes a Security Update

Production
ProductVersion ProductLevel Edition EngineEdition
9.00.3042.00 SP2 Enterprise Edition (64-bit) 3
GSquared
GSquared
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23665 Visits: 9730
Does the data on this page help: http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
arussell_10
arussell_10
SSC-Enthusiastic
SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)

Group: General Forum Members
Points: 168 Visits: 1326
I will check it out and reply back. Thank you.
arussell_10
arussell_10
SSC-Enthusiastic
SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)

Group: General Forum Members
Points: 168 Visits: 1326
GSquared,

According to the link, it appears that I only need to install SP3 and then the Security Update. Do you know if I'm reading that correctly?

Patch Level Link Build Version
2005+SP3 (Q970892) GO 4,053 9.00.4053
GSquared
GSquared
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23665 Visits: 9730
Looks like.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
curious_sqldba
curious_sqldba
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2938 Visits: 3637
arussell_10 (1/21/2011)
All,

I just started at a new company and need a way to determine which patches have been installed on a server. My dev box and Production cluster are not patched the same (details below). I want to at least get Production to match Dev.

1) Is there a way to tell if any other CUs or Patches were applied to Dev in between the Security Update and SP3?
2) Can I just apply SP3 and the Security update to production?

Development
ProductVersion ProductLevel Edition EngineEdition
9.00.4053.00 SP3 Enterprise Edition (64-bit) 3 --- includes a Security Update

Production
ProductVersion ProductLevel Edition EngineEdition
9.00.3042.00 SP2 Enterprise Edition (64-bit) 3


i) you can get the patches/CU's install history from setup bootstrap folder
ii) i would first install on dev, let it run for few days and then install on production.Just an FYI, if you want the list of all SP's and CU's this link http://www.sqlservercentral.com/articles/Administration/2960/ might help.

Thanks
arussell_10
arussell_10
SSC-Enthusiastic
SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)

Group: General Forum Members
Points: 168 Visits: 1326
GSquared, Thank you!

sqldba_icon,
The dev server I have already has SP3 and the security update installed, but I didn't do the installs. I don't have another place to test this yet I have to install it in production. This is not my call, but I have to make it work. I have started checking the files listed in this link (http://msdn.microsoft.com/en-us/library/ms143702(v=sql.90).aspx) but I'm not really sure what to look for. Any ideas? I also have a folder in Setup Bootstrap\Log called Hotfix.
curious_sqldba
curious_sqldba
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2938 Visits: 3637
arussell_10 (1/21/2011)
GSquared, Thank you!

sqldba_icon,
The dev server I have already has SP3 and the security update installed, but I didn't do the installs. I don't have another place to test this yet I have to install it in production. This is not my call, but I have to make it work. I have started checking the files listed in this link (http://msdn.microsoft.com/en-us/library/ms143702(v=sql.90).aspx) but I'm not really sure what to look for. Any ideas? I also have a folder in Setup Bootstrap\Log called Hotfix.


I am confused here. If you already have SP3 and CU installed on dev box and it is running fine then why cant you install on prod? If you are trying to mimic the same SP and CU as ur dev box is onto prod and not sure which ones are those then run "select @@version on you dev box", search with the version number (last four digits) from the SSC article which i sent you. Is that what you are looking for?
arussell_10
arussell_10
SSC-Enthusiastic
SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)

Group: General Forum Members
Points: 168 Visits: 1326
No. Sorry for the confusion. Here is what I know. My dev SQL Server has SP3 and a security update on it to make it 9.00.4053.00 SP3 Enterprise Edition (64-bit) 3. I think that is all.

Here is what I want to know. Is it possible that the previous DBA installed another CU or Patch in between SP3 and the Security update? For example, did the previous DBA install SP3, CU2 and then the Security update or just SP3 and Security update. (I think the SP3 and Security update is correct.) My fear is that somehow I miss a CU or patch and then my Production doesn't match my Dev.

Does that make sense? If not, please let me know and I will try to explain it better.
arussell_10
arussell_10
SSC-Enthusiastic
SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)SSC-Enthusiastic (168 reputation)

Group: General Forum Members
Points: 168 Visits: 1326
sqldba_icon,

I looked at the build list again and it appears that there were no updates or patches released in between SP3 and the Security update. So, there can't be anything installed in between them. Thank you!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search