ms sql 2008 R2 sp install problem

leop1212
leop1212 used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Technical Architect, Capgemini India
Commented:
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.

Author

Commented:
SP3 here is a file name for SP3 SQLServer2008R2SP3-KB2979597-x64-ENU .I update two other 2008R2 without any problems
Nakul VachhrajaniTechnical Architect, Capgemini India

Commented:
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.

Author

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial