question

bmurali09 avatar image
bmurali09 asked

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
sql server 2012sql server 2014
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Why is it urgent? What issues are you seeing?
0 Likes 0 ·

1 Answer

· Write an Answer
JohnM avatar image
JohnM answered
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!
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

But i'm confusing to install on which Service Pack need to install on which environment.
0 Likes 0 ·
Is we need follow one by one like First need to install SP1 and after SP2 and at last SP3? or else directly we can install SP3?
0 Likes 0 ·
No, you can just install SP3 (includes all the fixes in previous SPs). I would however test the installation of SP3 before applying to production
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.