Skip to main content
Solved

BackupAge on sql server

  • December 15, 2021
  • 3 replies
  • 220 views

Forum|alt.badge.img+10

Hello watchers,

 

I have a little issue with backupage monitoring on SQL server.

I explain:

We have multiple MSSQL servers in our organization.

We configured MSSQL plugin to monitor them.

We do a full backup every friday and an incremental every day (Tlogs every hour).

In Centreon, it seems it just take the full backup value to have the backupage value. 

Is it normal? How can I do the value of backupage take in count the incrementals?

 

Regards,

 

Laurent

Best answer by lchrdn

Hello Laurent, 

Indeed the MSSQL plugin can only check full backups' age, it would be an interesting improvement to take into account incrementals.

To request an improvement on the plugin, you can open an issue on our Github : https://github.com/centreon/centreon-plugins/issues/new/choose
You'll have to provide us with the sql requests and expected results to check the incremental backups. 

Best Regards,
Laetitia

3 replies

rchauvel
Centreonian
Forum|alt.badge.img+18
  • Centreonian
  • December 15, 2021

Moved to Platform


Forum|alt.badge.img+3
  • Centreonian
  • Answer
  • December 16, 2021

Hello Laurent, 

Indeed the MSSQL plugin can only check full backups' age, it would be an interesting improvement to take into account incrementals.

To request an improvement on the plugin, you can open an issue on our Github : https://github.com/centreon/centreon-plugins/issues/new/choose
You'll have to provide us with the sql requests and expected results to check the incremental backups. 

Best Regards,
Laetitia


Forum|alt.badge.img+3
  • Steward *
  • January 27, 2022

The development had be done to manage incremental/log/full backup:

https://github.com/centreon/centreon-plugins/pull/3333

It will be released in february!