Solved

ms sql 2008 R2 sp install problem

Posted on 2016-07-19
4
48 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 11

Accepted Solution

by:
Nakul Vachhrajani earned 500 total points
Comment Utility
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
Comment Utility
SP3 here is a file name for SP3 SQLServer2008R2SP3-KB2979597-x64-ENU .I update two other 2008R2 without any problems
0
 
LVL 11

Expert Comment

by:Nakul Vachhrajani
Comment Utility
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
Comment Utility
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.

763 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now