Update the SQL patch

  • Hi,

    IS there any process of applying SQL patch in SQL Production Server. For a instance , 3 years old production database I need to update the new patch. Can you explain ?

  • How can you have a SQL 2008 database that is 3 years old? Uhmmmmm, SQL 2008 came out in...well, 2008 and it is only 2010, that is only 2 years.

    Andrew SQLDBA

  • - Read the according KB ref for the hotfix !!

    - Test it on a DBA test server to prepare yourself for the production rollout (timing, expected problems,..)

    - Is this a service pack or are you actually talking of a single hotfix ?

    (If you have the option, go for the service pack, because we expect that to be better tested)

    - As always, play it safe and start with a Full database backup of all databases of your instance ! (including the resource database (sql2005/2008))

    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

  • thanks for the reply.

    can you tell about single hotfix and service pack ?

  • And there are off course "cumulative hotfixes" = a set of hotfixes, but not as tested a you would expect for a service pack

    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

  • Same rules apply to service packs. Service packs will list the hotfixes involved in the SP. Read the kb's - test in dev and then promote through your environments if testing is satisfactory.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • I thing Service Pack = Many Hotfixes. Is there any good article that describes as how to apply the service pack or hotfixes?

Viewing 7 posts - 1 through 6 (of 6 total)

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