I have a similar process which runs a sproc on each server which performs a LOAD HEADERONLY on each dump device which populates a central db with details of the backups for each server and database. A website and email notification lets me know if there are any databases without current backups on disk.
It's been working well for several years.
anyone got a job that will: 1. create a test database; 2. restore a backup into the test database; 3. verify that the restore succeeded; 4. delete the test database.
Now that would be a good test of current/available backups!
Although I am new at this, it didn't take long to get this set up on my workstation, and its great!. The question I have is, how do I get this to check all of the servers, or do I just have to set it up on each server?