Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 137
  • Last Modified:

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.
0
leop1212
Asked:
leop1212
  • 2
  • 2
1 Solution
 
Nakul VachhrajaniTechnical 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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now