I am getting below error message after installing cumulative updates for SQL Server 2016 Sp1.
The description for Event ID 7024 from source Service Control Manager cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
SQL Server (MY_INSTANCE_DEVELOPMENT) %%3417
The locale specific resource for the desired message is not present
I have 2 instances on that server, DBA16 AND DEVELOPMENT.
DBA16 started up nicely and no problem, but DEVELOPMENT is not starting.
I tried to start the service manually and get the same problem.
I have applied these same updates on several servers, including clustered ones, with alwaysOn and replication, and had no problems.
Replication distributor also worked fine.
This server in particular, I could find no reason for these problems.
I might have to re-install sql server or rebuild the instance, if it is related to corruption in some file, or the master database.
is there anything I should be aware of or might have not looked\considered?
There is a similar question here: Start service error code 3417 with SQL Server 2012
Script level upgrade for database 'master' failed because upgrade step 'msdb110_upgrade.sql' encountered error 15173, state 1, severity 16. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.