Installing SP2 on SQL Server 2008R2 RTM (Standard)

  • Need to install the latest service pack on SQL Server 2008 R2 RTM (Standard Edition). Please let me know if anyone of you have done this before. Please share the steps you followed. Do you remember facing any issues or errors while doing this?

    M&M

  • For a Non Clustered SQL Server:

    Test this all before you do production of course. Take db backups of all dbs before you do this as well and test, test,test your apps.

    Stop all unneeded services in Services like Anti Virus, Backup software, IIS, etc....

    Make sure all user connections are down as SQLServer will go down and back up during the SP apply.

    Simply start the Service pack and walk through the wizard. It does the rest.

  • I have installed without issues.

    As above but make sure you have administrator rights on the box and to run the patch, right click and select 'run as administrator'

    ---------------------------------------------------------------------

  • As others have pointed out, it's fairly straight forward, point and click through the wizard.

    If you do run into issues, review the installer logs under C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\log\.

    You'll get a subfolder for each time the installer runs.

  • Thank you for all the inputs. 🙂

    M&M

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

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