Werk #15314: mssql_backup: fix 'no backup found' for case-insensitive databases

Component

Checks & agents

Title

mssql_backup: fix 'no backup found' for case-insensitive databases

Date

Dec 12, 2023

Level

Trivial Change

Class

Bug Fix

Compatibility

Compatible - no manual interaction needed

Checkmk versions & editions

2.3.0b1 Not yet released	Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk Cloud (CCE), Checkmk MSP (CME)
2.3.0b1	Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk Cloud (CCE), Checkmk MSP (CME)
2.2.0p18	Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk Cloud (CCE), Checkmk MSP (CME)

In certain circumstances it was possible that the mssql.vbs agent plugin returned no backup found because it could not map the found backup to the database.

The reason for that was, that the comparison between the backups database name and the database name was case sensitive, but its possible to configure mssql in a way that backups database name and database name does not match case sensitive.

We now compare both names on the mssql server so the configured case sensitivity is respected.

To the list of all Werks