locked
More noisy alerts - MSSQL 2014 recovery model configuration error RRS feed

  • Question

  • Hi,

    In SCOM 2016 environment we are getting more number of noisy warning alerts for the below MSSQL 2014 DB class.

    Alert name:- MSSQL 2014 recovery model configuration error

    Please confirm can we go ahead with override changes to minimize the alerts.

    Thanks,

    Dileep

    Wednesday, July 25, 2018 1:26 PM

Answers

  • Hello Dileep,

    It checks recovery model setting for DBs & is expected to set to FULL. You have to change the configuration setting for the DBs (if no concern) or you can simply override the monitor as per your needs.

    (Please remember to "Mark as Helpful/Mark as Answer" if applicable)

    Thursday, July 26, 2018 7:29 AM
  • Hi Dileep,

    in addition to the explaination above I can add the link to the particular unit monitor, which contains plenty of additional information:

    Microsoft.SQLServer.2014.Database.Configuration.RecoveryModel (UnitMonitor)

    Hope this helps you out. 

    Regards,


    (Please take a moment to "Vote as Helpful" and/or "Mark as Answer" where applicable. This helps the community, keeps the forums tidy, and recognizes useful contributions. Thanks!) Blog: https://blog.pohn.ch/ Twitter: @StoyanChalakov

    Thursday, July 26, 2018 7:34 AM

All replies

  • Hello Dileep,

    It checks recovery model setting for DBs & is expected to set to FULL. You have to change the configuration setting for the DBs (if no concern) or you can simply override the monitor as per your needs.

    (Please remember to "Mark as Helpful/Mark as Answer" if applicable)

    Thursday, July 26, 2018 7:29 AM
  • Hi Dileep,

    in addition to the explaination above I can add the link to the particular unit monitor, which contains plenty of additional information:

    Microsoft.SQLServer.2014.Database.Configuration.RecoveryModel (UnitMonitor)

    Hope this helps you out. 

    Regards,


    (Please take a moment to "Vote as Helpful" and/or "Mark as Answer" where applicable. This helps the community, keeps the forums tidy, and recognizes useful contributions. Thanks!) Blog: https://blog.pohn.ch/ Twitter: @StoyanChalakov

    Thursday, July 26, 2018 7:34 AM