Skip to main content
Solved

BackupAge on sql server

  • Dec 15, 2021 1:24 PM UTC
  • 3 replies
  • 250 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

View original

3 replies

rchauvel
Centreonian
Forum|alt.badge.img+18
  • Centreonian
  • Dec 15, 2021 2:05 PM UTC

Moved to Platform


Forum|alt.badge.img+3
  • Centreonian
  • Answer
  • Dec 16, 2021 2:21 PM UTC

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 ***
  • Jan 27, 2022 4:21 PM UTC

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!