List SQL backups

During the process of developing a script to make copies of local SQL database and transaction log backups, I needed to come up with an easy way of locating the backup files. This script queries the SQL2000 backup tables in the msdb database and returns backup start dates, types (D=database, L=Log, I=Differential) and the location of the backup file.

The variable @DBName should be set to the name of the database you want to query on. It is not case sensitive unless your collation is.

The variable @Days should be set to how many days back in the records you want to list backups for.