Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Installing SP2 on SQL Server 2008R2 RTM (Standard) Expand / Collapse
Author
Message
Posted Sunday, September 30, 2012 7:51 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 5:49 PM
Points: 2,263, Visits: 3,758
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?

Mohammed Moinudheen
Post #1366305
Posted Monday, October 01, 2012 6:05 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:52 AM
Points: 1,201, Visits: 2,658
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.



Post #1366508
Posted Monday, October 01, 2012 7:44 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 10:14 AM
Points: 5,844, Visits: 12,571
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'


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

Post #1366565
Posted Monday, October 01, 2012 10:35 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 3:26 PM
Points: 316, Visits: 1,497
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.

Post #1366655
Posted Monday, October 01, 2012 7:50 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 5:49 PM
Points: 2,263, Visits: 3,758
Thank you for all the inputs.

Mohammed Moinudheen
Post #1366849
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse