My approach reads the system tables to determine where the backups are. Now if you move the backup files to another drive then this is not recorded in the system tables, and would make it harder to write a script to find them. I suppose the script could be easily modified if you always have a specific directory in which you moved the backups, and you kept the backup name the same. Is this your case?

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.sqlserverexamples.com