I have read the article on MSSQL Tips website.

The system views do provide useful information about the backups.

In my opinion, the following things are missing:

1. In their example, you can check if the backup has run in the past 24 hours by doing a select on a system view. This works on the assumption that the backup must run at least once. What you could have, is a backup schedule table where you as a DBA can specify what type of backup you want to perform and how often.

2. I believe those system views are missing in SQL 2000, you'll have to check this.