Post reply

SOmething weird with SQL patching

  • September 21, 2015 at 7:30 pm

    #307818

    Hi all ,

    I just did SQL patching ( Service pack 3) to my testing server and it turns out that only SQL browser and writer have been updated but not for SQL instance.

    So the SQL instance still Service pack 1 .

    This kind of weird .

    Anyone has experience with it ? Much appreciate on your response.

    cheers

  • September 22, 2015 at 4:56 am

    #1828321

    you are on which SQL Server version?

  • September 27, 2015 at 7:31 pm

    #1829787

    Hey thx for the reply ,

    SQL version is 2008 R2

  • September 28, 2015 at 3:27 am

    #1829815

    Hi,

    are you using a singel instance, or a part of a cluster?

    Andreas

  • September 28, 2015 at 7:33 am

    #1829868

    WhiteLotus (9/21/2015)

    Hi all ,

    I just did SQL patching ( Service pack 3) to my testing server and it turns out that only SQL browser and writer have been updated but not for SQL instance.

    So the SQL instance still Service pack 1 .

    This kind of weird .

    Anyone has experience with it ? Much appreciate on your response.

    cheers

    You've likely only applied the SP to your desktop. I could be wrong (the folks in Netops do these things where I work) but I believe you'll need to RDC into the server and apply the patches while logged into the server itself.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 5 posts - 1 through 4 (of 4 total)

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