Just one problem with the above, and that's xp_delete_file. It's notoriously flakey and as of the current release of SQL Server 2005 SP2(a), you simply can't rely on it to delete your old backup files. It will run and report success, but won't delete anything. Search +xp_delete_file +problem on any search engine, it's a royal pain...

it's true...  i've tested this many times in 9.00.3042.00  SP2  and the behavior still exists.

i've seen many versions of this procedure; and is still random results. 

i dont' recommend using it at all.

it's also a 2000 left-over; so eventually MS will probably have it depricated.

beware