What is the best way to install service pack in sql server 2012 standard edition
Hi, This is urgent, Please help me to install service pack in our Production Environment. Our configuration is: Sql Server 2012 Standard Edition with RTM, 64 Bit, Windows 2008 R2 Standard with SP1. Client server Configuration is : Windows 2012 R2 Standard and SQL Server 2014 with SP1 and one more is SQL 2012 WITH SP2. My requirement is whether I want to install SP1 or else SP2. Please provide me solution with steps. Regards Murali
Unless there is a specific reason for SP2, I'd go straight to SP3. You would want to install and test it to ensure it doesn't affect any databases/applications but the install process is fairly straight forward. Just launch the install package and follow the GUI prompts. Note that your instance will be offline while the service is being installed so plan accordingly.
http://sqlserverbuilds.blogspot.com/ Hope that helps!