When I check drive E, it has one of the databases backup files but with the file size of 0, which obviously means that nothing has been backed up.

The script that you sent to check the Backup status throws an error; does it work for SQL 2000 Servers?

Thank you for your help.