I created backup devices and scripted jobs for full, differential and transactional backups and included retain parameters using SQL Server 2000. When I look at the "Management, Backup, DeviceName,View Backup Media Contents" I can see all of the logs that were created and it shows me the ones that were expired.
What I need to find out is how to delete these expired logs. First, how do I delete the ones that are in existence already, and second, what code do I include in my jobs to delete these logs as soon as they are expired.
Any help would be appreciated.