• Replies 5 replies
  • Subscribers 7 subscribers
  • Views 3719 views
  • Users 0 members are here
Options
Related

Factory Alarms - Days Since Last Full Backup

Serge Maslov
over 4 years ago

Hi all,

I have noticed that Spotlight would raise Days Since Last Full Backup alarm with "A full backup has never been taken for database XXXXX" message whenever a new DB is created but the first scheduled backup not yet occurred.

I am just wondering if it would be practical if Quest could modify this deaulf (factory) alarm to account for the DB creation date/time. So, basically, if a new DB was created but the time between the creation and now has not reached the first threshold the "full backup has never been taken" should not be displayed. This would eliminate false alarms and make it cleaner. I know that the entry with the threshold from -1 to 0 can be completely removed/disabled, but it is not the most elegant solution, as it would be beneficial for a DBA to distinguish between the situation when a backup never occured for a DB and a backup has not been taken for certain period of time. Also, I know that this goal can be achieved with custom alarms (custom query), but I think fine-tuning the factory alarm would be more convenient.

What are your thoughts?

  • over 4 years ago

    Hi Serge,
    I'm assuming you're referring to the Database Backup alarm of our Spotlight Cloud application and not Spotlight on SQL Server Enterprise. If you can confirm that please.

    Note, there are two distinct Database Full Backup alarms: "Backup - A full backup is not defined" and "Backup - Days Since Last Full Backup". Having said that, the "Backup - A full backup is not defined" alarm doesn't account for the database creation time and so the alarm could be falsely raised in that case with default settings. I can place in a product enhancement request once I know the product you're using.

    Gita Sharifi
    Spotlight Support Team

  • over 4 years ago

    Hi Gita,

    No, I am speaking about "Backup - Days Since Last Full Backup" alarm in Spotlight on SQL Server Enterprise. AFAIK, there is no factory default alarm called "Backup - A full backup is not defined" in Spotlight on SQL Server Enterprise.

    Thanks.

    Serge

  • over 4 years ago in reply to Serge Maslov

    Thanks Serge for confirming that. The alarm "Backup - A full backup is not defined" exists in our other Spotlight product (Spotlight Cloud) so I just wanted to confirm the product you're using.

    You're right, the alarm doesn't taken into count the timing of database creation. But keep in mind the default collection of this alarm, when application is open, is at every 30 minutes, and at 1 day when application is closed. So there's a window of time, depending on when database was created, before alarm fires off. Having said that, your request can make for smarter alarm logic.  I'll place in the request with the product team and share the related KB article soon.

  • over 4 years ago in reply to Serge Maslov

    Hi Serge,

    KB Article 310970 was created for this product enhancement request.

    Gita