Post reply

service pack installation

  • February 12, 2013 at 11:17 am

    #270799

    For service pack for SQL servers, we so far have not failed, but I would like to know if there are some cases of failing service pack, and how to fix it,

    is there a case we need to uninstall it?

    And if uninstall, shall we just do in control panel -unstaill or change a program.

    Any other troubleshooting tips?

    Thanks

  • February 12, 2013 at 3:28 pm

    #1587228

    Hi,

    If you don't have a clustered environment I would not worry a lot since the patch/service pack installation will rollback if there is any issues. If it is a clustered environment then you need to do some preparation on failing over the cluster manually before patching. Or you can patch the passive node first and fail-over the server.

    I recently did a service pack update from 2008 R2 RTM to SP2 and it went smoothly on my machine.

    Try to disable the jobs that run in the same time if there are any. SQL server might restart in this process so some jobs that are designed to run when the SQL server starts may start along with it.

    Since a SQL server needs a restart after the patch, you may want to schedule a time where there is low activities on the server.

  • February 12, 2013 at 3:49 pm

    #1587232

    Thanks, we don't have clustered servers.

    When you say it failed it will roll back, does it give out some information said it has rolled back, or it simply say the intallation or upgrade failed.

    How do we know it is rolled back?

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

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