Would like a script to perform sanity checks to ensure one (or more) databases are being backed up.
1) Check that SQL backup job ran successful
2) Check that database backup file is present
3) check that database drives (mdf, ldf) space is not filling up post backup.
4) email results of given checks
C# may be a quick and easy way to perform these checks.