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.