January 21, 2011 at 12:41 pm
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
ProductVersionProductLevelEditionEngineEdition
9.00.4053.00SP3Enterprise Edition (64-bit)3 --- includes a Security Update
Production
ProductVersionProductLevelEditionEngineEdition
9.00.3042.00SP2Enterprise Edition (64-bit)3
January 21, 2011 at 12:46 pm
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
January 21, 2011 at 12:51 pm
I will check it out and reply back. Thank you.
January 21, 2011 at 1:00 pm
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
January 21, 2011 at 1:18 pm
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
January 21, 2011 at 1:43 pm
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
ProductVersionProductLevelEditionEngineEdition
9.00.4053.00SP3Enterprise Edition (64-bit)3 --- includes a Security Update
Production
ProductVersionProductLevelEditionEngineEdition
9.00.3042.00SP2Enterprise 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
January 21, 2011 at 2:27 pm
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.
January 21, 2011 at 2:55 pm
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?
January 21, 2011 at 3:25 pm
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.
January 21, 2011 at 4:21 pm
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!
January 22, 2011 at 12:22 pm
just an fyi, for each security update and CU the version number will change.
January 23, 2011 at 2:59 pm
the important point here is that both Service Packs and Cumulative updates are Cumulative, they contain everything that went before them.
So if you apply SP3 and the security fix to bring you up to 9.00.4053 then you can be sure your SQL builds are identical
---------------------------------------------------------------------
January 24, 2011 at 9:51 am
Thanks all!
I was originally worried I would install SP3 and Security update (.4053) and think I got everything. However, there would have been an additional CU or Security update installed right after SP3 and I wouldn't know. Like the example below.
SP3
CU or Security update ---worried I would miss this one because I can't tell its installed based on 9.00.4053.00
Security update (.4053)
But based on the build list (http://www.sqlservercentral.com/articles/Administration/2960/) it appears that SP3 came out and then the Security update (.4053) that I need. So no other items should be installed in between SP3 and Security update (.4053).
Thanks again!
January 24, 2011 at 12:07 pm
arussell_10 (1/24/2011)
Thanks all!I was originally worried I would install SP3 and Security update (.4053) and think I got everything. However, there would have been an additional CU or Security update installed right after SP3 and I wouldn't know. Like the example below.
SP3
CU or Security update ---worried I would miss this one because I can't tell its installed based on 9.00.4053.00
Security update (.4053)
But based on the build list (http://www.sqlservercentral.com/articles/Administration/2960/) it appears that SP3 came out and then the Security update (.4053) that I need. So no other items should be installed in between SP3 and Security update (.4053).
Thanks again!
As far as my knowledge goes CU or security update will change the version number. So if CU was installed after Sp3 the version number would be changed.
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply