Check Backups on Multiple Servers

I've just finished the backup checking on my SQL Server Admin tool program so you can check the state of the server backups all from one screen as shown below.




I’ll explain what checks I do, when you click the “Check Backup Status” button it will go off and check the msdb tables for the most recent database backup for each table, it gets the time and size and location, the software will then attempt to go and find the backup file and check the size and date stamp against what is stored in the database as a kind of quick verify.

There’s also another button called “Verify Backup with SQL” what this will ask the SQL Server to runs a restore on the backup set with the VERIFYONLY flag set to make sure that the file is valid, all of this is done in a threaded environment so that there is no program hang and multiple servers can be checked at once.

Next task for the program is replication validation.