Which hot fix should I install after I install SQL server 2005 SP2?

  • I just installed active/passive clustered SQl server in brand new boxes and will migrate our production SQl 2000 server to this cluster server.

    SQL Server version is 9.0.3042. 64 bit.

    Is it necessary to install the latest Hot fix which is Cumulative update package 10 for SQL Server 2005 Service Pack 2?

    If not, what problem will I meet?

    Thanks

  • Ah, the $64,000 question that has annoyed dbas about SQL 2005 for a while now, whether or not to apply cumulative updates. You will note that microsoft says not to apply them unless you have actually had a problem fixed by the update, so I have plumped for not applying them, many others will differ on that opinion.

    Your timing is awful as SP3 should be out very soon on general release and that I would apply. It is roughly equivalent to CU9, but fully tested, which is the crux of the matter.

    Having said all of the above, the least you should do after SP2 is apply GDR2, see

    http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx

    and there is a critical security hotfix I cant find at the moment, will get back to you....................

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

  • Don't apply any that you don't actually need. That's what Microsoft recommends, and I tend to agree with them on that point.

    - 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

  • but if you're going to use maint plans, apply at least CU2 (current = CU10 and sp3 is in public beta)

    For the moment we apply CU10 for new installations. (didn't encounter issues with it).

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • I think CU6 was stable on clusters, though I haven't heard a lot since then. You might email Geoff Hiten, SQL MVP that does a lot with clusters.

    I would go post SP2 because SP2 has some issues. SP3 is due in the next month, so I might also start testing that.

  • Thanks for all replys.

    Actually, I did meet Check DB problem when I run scheduled maintenance job to do integrity check. It only check master database. For this problem, I guess, if I write a Stored procedure to do dbcc checkdb against every database, I don't need to apply Hot fix for this.

  • Judy, there were lots of problems with maintenance plans with SP2, please apply at least GDR2.

    that security hotfix - I am pretty sure was MS08-052, but I'm not 100% sure as I'm not in the office. Can anyone confirm,? steve, I would have picked it up from database weekly recently.

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

  • On this subject I have a quick question. I can't recall since it's been awhile since I've seen an install of SQL but is it possible to apply hotfixes, cumm updates, and SPs to a specific named instance in a active/passive setup?

    I normally just handle installing SSRS and there is always just the default instance, but it seems if I recall you can tell it which instance to apply to or all, right?

    So, I would think that would apply to SQL Server. Just checking for my FYI.

  • Actually, I applied SP3 at my new active/passive Cluster server and did test. Everything looks fine for SP3. But our SAN was broken somehow and every setting on both nodes is corrupt. We had to rebuild everything from scratch. That is another disgusting story.

  • russell.sage (2/19/2009)


    On this subject I have a quick question. I can't recall since it's been awhile since I've seen an install of SQL but is it possible to apply hotfixes, cumm updates, and SPs to a specific named instance in a active/passive setup?

    I normally just handle installing SSRS and there is always just the default instance, but it seems if I recall you can tell it which instance to apply to or all, right?

    So, I would think that would apply to SQL Server. Just checking for my FYI.

    Actually you can apply it instance per instance, so instances can be on different software levels.

    However, some shared components (xml, client components,..) will get upgraded.

    Also keep in mind, when applying it to a first instance, you'll have to reboot the node(s)

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Judy (2/19/2009)


    Actually, I applied SP3 at my new active/passive Cluster server and did test. Everything looks fine for SP3. But our SAN was broken somehow and every setting on both nodes is corrupt. We had to rebuild everything from scratch. That is another disgusting story.

    We didn't encounter that on our san related systems.

    What do you mean with "every setting is corrupt"?

    Which settings were corrupted ?

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • Sorry to hear about your bad luck Old Hand. We're looking to upgrade our Development to SP3. That's why I asked the question so I could speak to it if it came up.

    Thanks SSCarpal Tunnel for the answer. That's what I thought but wasn't sure. I couldn't find anything specific like an article that explained it this is good enough.

    I mis-spoke though earlier when I said it's an active/passive setup. It's active/active (two node).

  • It was not related to SP3 installation. We used to have one big physical drive which crossed two Arrays. And then this physical drive was seperated into three logical drives. One of Arrays was removed. it caused another array stopped working. All the clustering settings were corrupted.

  • Judy (2/19/2009)


    It was not related to SP3 installation. We used to have one big physical drive which crossed two Arrays. And then this physical drive was seperated into three logical drives. One of Arrays was removed. it caused another array stopped working. All the clustering settings were corrupted.

    You should have added this info to your previous post !

    It is critical to know SP3 didn't cause the failure !

    In many cases, people will put a cumulative hotfix or sp on a hold if they read this kind of messages in a posting !

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • My Fault!

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

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