ms sql 2008 R2 sp install problem

MS SQL server 2008 2 and version is 10.50.6000.34
When I tried to install SP2 or SP3 it Service pack will report that it doesn’t see any instance to patch
While scan reporting that SQL server is not parched. I ran full install repair but problem still exists.  
What is the best way patch the server preferably without full reinstall and minimum down time.
 i am not looking for  straight forward solution : (uninstall SQL, install fresh 2008r2 and install sp2) as this is our production server with few key database running.
leop1212Asked:
Who is Participating?
 
Nakul VachhrajaniConnect With a Mentor Technical Architect, Capgemini IndiaCommented:
The SP2/3 package that you are using is for SQL 2008 R2 or vanilla SQL 2008? Both are different and cannot be run across each other (i.e. a SQL 2008 SP2 will not install on SQL 2008 R2). Can you cross-check?

If I am not mistaken, the license agreement screen of the SP install program should tell you which release of SQL Server is the SP intended for.
0
 
leop1212Author Commented:
SP3 here is a file name for SP3 SQLServer2008R2SP3-KB2979597-x64-ENU .I update two other 2008R2 without any problems
0
 
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
Sorry to have not seen it earlier - If your SQL instance is already on "10.50.6000.34", it means that it is already on SQL Server 2008 R2 SP3.

Per (https://support.microsoft.com/en-us/kb/2979597),

Note After you install the service pack, the SQL Service version should be reflected as 10.50.6000.34.
0
 
leop1212Author Commented:
well,
but when I tried to upgrade one of my Database it tells me that SQL is not upto date and reported that SP3 is not installed
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.