Skip to Content
avatar image
Former Member

How to monitor Log Backups for MS SQL Server

Hello all.

We are running Solution Manager 7.1 on SP Stack 10 and have downloaded the latest template content.

When configuring the templates for DB monitoring, we noticed that although there is a metric that monitors the age of the last DB backup, there is no such metric to monitor the age of the last successful Log backup, or even a metric to alert us on a failed backup / log backup.

Has any of you ever had to create a custom metric to monitor either the age of the latest successful log backup for MS SQL Server, or a custom metric to alert on failed backups / log backups?

If yes, could you provide some instructions on how to create such a metric?

Thank you in advance for your answers.

Phevos

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 29, 2014 at 10:19 AM
    • Former Member

      Hello Chinna.

      Thank you for those links. I have gone through them in the past few days and that is the reason I ended up posting here šŸ˜Š

      My main problem is I can't find a corresponding MTE in RZ20 in order to create the custom metric. Sorry for not mentioning that in my original post.

      Once again thank you for your reply.

      Phevos

  • Jul 29, 2014 at 10:38 AM

    Hi Phevos,

    You can use custom monitoring using log files to read data.

    Refer my thread:

    Use the setup metioned above technical monitoring custom template.

    Divyanshu

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Divyanshu Srivastava

      Hello Divyanshu.

      Solman 7.1 SP Stack 10, on Windows Server 2008 R2 and MSSQL Server 2008.

      If you need any extra info please let me know.

      Also please note our scenario is central monitoring for a series of landscapes including almost every possible SAP installation (ERP, BI, PI, CRM etc) and various OS / DB combos (Windows 2003, 2008, 2012), Red hat Linux, Linux Suse etc, MS SQL Server, Oracle, DB2 and HANA.

      We have configured and monitor over 200 systems. So far we have been concentrated in plugging in all the monitored systems and now is the time of fine tuning and evaluation of our existing templates/monitors. šŸ˜Š