Received a task to upgrade service pack of SQL Server 2008. Looks so simple rite yeah I felt so…. See how it went
Copied SP1 file to server and ran the file it took 5mins after running the exe and thrown below error.
So as per my observation the options are either to run REPAIR if it fails then try re-installing the respective service and if that also fails we should re-install SQL SERVER. I would be happy to hear if any other ways of fixing this issue.
Then started upgrade of other instances where I haven’t touched As service still. It went for some time…..
and went till end successfully J
So finally upgraded all instances with SP1.