Post reply

Repair after sp1 question

  • August 18, 2009 at 4:06 pm

    #135582

    Hi,

    I have SQL SERVER 2008 SP1.

    If I do a repair, do I have to re-apply SP1?

    Thank you,

    Richard

  • August 19, 2009 at 5:45 am

    #1041415

    Hi Richard,

    by repair I'm assuming you mean you are rebuilding your system databases? If so, yes, you need to re-apply the service pack.

    HTH 🙂

  • August 19, 2009 at 10:10 am

    #1041687

    Actually I meant the add/remove/repair features utility.

    I just did it anyway to basically re-install the client tools (some corruption there).

    Afterwards I re-applied SP1 but it said no services needed updating so that answer seems to be:

    no, we don't have to re-apply sp1 after a repair.

    Can anyone confirm???

    Richard

  • August 20, 2009 at 4:07 am

    #1042004

    Sorry Richard, I misunderstood.

    You're quite right, by adding components you don't necessarily have to re-apply the Service Pack to the Database Engine instance, although you still need to apply the patch to the new components.

    If in doubt regarding patching the DB Engine, you can check whether the patch is actually needed by comparing the version numbers from the following script:

    select serverproperty('ProductVersion'), serverproperty('ResourceVersion')

  • August 21, 2009 at 12:18 am

    #1042616

    Thanks!

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

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