Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

History of Patches Expand / Collapse
Author
Message
Posted Friday, January 21, 2011 12:41 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 1:52 PM
Points: 98, Visits: 1,191
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
Post #1051767
Posted Friday, January 21, 2011 12:46 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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
Post #1051769
Posted Friday, January 21, 2011 12:51 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 1:52 PM
Points: 98, Visits: 1,191
I will check it out and reply back. Thank you.
Post #1051774
Posted Friday, January 21, 2011 1:00 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 1:52 PM
Points: 98, Visits: 1,191
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
Post #1051783
Posted Friday, January 21, 2011 1:18 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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
Post #1051792
Posted Friday, January 21, 2011 1:43 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:31 PM
Points: 1,274, Visits: 2,938
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
Post #1051820
Posted Friday, January 21, 2011 2:27 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 1:52 PM
Points: 98, Visits: 1,191
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.
Post #1051843
Posted Friday, January 21, 2011 2:55 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 3:31 PM
Points: 1,274, Visits: 2,938
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?
Post #1051859
Posted Friday, January 21, 2011 3:25 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 1:52 PM
Points: 98, Visits: 1,191
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.

Post #1051873
Posted Friday, January 21, 2011 4:21 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 1:52 PM
Points: 98, Visits: 1,191
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!
Post #1051885
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse