A little problem that I'm struggling to solve in HM
We have an active/passive MS SQL database mirror running on two hosts.
We monitor these hosts for backup and transaction log backups. Of course the passive partner doesn't do any transaction log backups, as it doesn't need too. So the test is always failed .. but if its partners is OK, this is no problem. The database can switch to it's mirror partner for some time so it's not predictable which will be 'Active'.
So is there an elegant way to make a tests status depend on the status of another, and can it be two way (i.e. a logical OR of the tests status, and set both to the result with Good = 1 Bad = 0)
Cheers for any ideas
