If you backup your databases to a disk file, you should make sure that these disk files are then being archived to tape. Without this, your ability to recover the database is compromised in the event of a disaster. This script will examine the "archive" flag on all of the backup files to make sure the system administrators have really archived them. It is set to examine all backups for the past three days but can be easily changed to be more or less. Any files which have NOT been archived (if any) will be kept in a temporary file. Once finished, you can then save this information to a repository, text file, e-mail, etc.
Is there a way I can automate a file deletion process from within SQL Server?