SQL scripts to fix event 18054 errors in SQL application log – in SCOM 2012R2

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,

 
 
 
 
 
4.5 Star
(2)
1,166 times
Add to favorites
System Center
2/10/2016
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • How about SCOM 2016
    2 Posts | Last post September 18, 2018
    • We have configured SQL 2016 with SCOM 2016. The AlwaysOn config does not synchronize the msdb. Can we use this query for the other nodes?
    • No, they are slightly different. I have a script that will work on both, but can't upload that yet. Will post here as soon as it's available.