These scripts add back the missing sysmessages into a SCOM 2012 R2 SQL server, which can be missing when you perform a database move or restore to a rebuilt SQL server.  These also might be needed when using AlwaysOn and failing over to a different server.

 

 

When SCOM is installed, it doesnt just create the databases on the SQL instance, it adds data to the sysmessages view for different error scenarios in the master database.

 

This is why after moving a database or restoring a DB backup, we might be missing this data.

 

There sysmessages are important because they give very good detailed data about the error and how to resolve it. 

 

These are for SCOM 2012 R2 ONLY.