Repair after sp1 question

  • Hi,

    I have SQL SERVER 2008 SP1.

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

    Thank you,


  • 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 🙂

  • 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???


  • 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')

  • Thanks!

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

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