Error Installing SQL Server 2005 Express Service Pack 4
Windows Server 2008 R2. Backup Exec 2010 R3. Microsoft SQL Server 2005 Express Service Pack 4.
I have traced a problem I am having with the Backup Exec services not coming back up after a reboot following automatic updates. The problem is associated with the automatic update of SQL Server 2005 Express Service Pack 4 failing. I am now trying to install this update manually by going to:
http://www.microsoft.com/download/en/details.aspx?id=184
and downloading SQLEXPR.EXE (the first download listed). The download page says that it is for SQL Server 2005 Express Service Pack 4. But when I run this download it gives me the impression that it is INSTALLING the entire product rather than UPDATING the product. I stopped the process before it actually started the install and came here to post.
MY QUESTION: Is it safe to run through the above mentioned installation without fear that it will overwrite or mess up anything I have already configured on my system, in particular the BEDB database that is currently running in the existing SQL Server 2005 Express instance?
Thank you for any help.
Nick Elmer of Symantec led me through the solution to this and another issue as follows (these are his words):
Positive Finish
For the benefit of others...
Got in touch with Chaplain Doug and identified that the mentioned technote above did apply to his system. (http://www.symantec.com/docs/TECH64580) We found the keys under the Wow3264 hive, removed them and the SQL SP4 installed via windows update successfully.
In addition, the system was also receiving failures running a Hyper-V backup, so we applied SP2 for Backup Exec without issue http://www.symantec.com/docs/TECH158461