September 30, 2012 at 7:51 pm
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
October 1, 2012 at 6:05 am
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.
October 1, 2012 at 7:44 am
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'
---------------------------------------------------------------------
October 1, 2012 at 10:35 am
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.
October 1, 2012 at 7:50 pm
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