asked on 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.
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.
Microsoft SQL Server 2008Microsoft SQL Server
Last Comment
leop1212
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
SP3 here is a file name for SP3 SQLServer2008R2SP3-KB29795
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),
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.
ASKER
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
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