Solved

ms sql 2008 R2 sp install problem

Posted on 2016-07-19
4
69 Views
Last Modified: 2016-07-20
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.
0
Comment
Question by:leop1212
  • 2
  • 2
4 Comments
 
LVL 13

Accepted Solution

by:
Nakul Vachhrajani earned 500 total points
ID: 41719859
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
 

Author Comment

by:leop1212
ID: 41719871
SP3 here is a file name for SP3 SQLServer2008R2SP3-KB2979597-x64-ENU .I update two other 2008R2 without any problems
0
 
LVL 13

Expert Comment

by:Nakul Vachhrajani
ID: 41720248
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
 

Author Comment

by:leop1212
ID: 41721035
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

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question