Thanks for the reply but is it possible to delete backups without maintenance plans? I am trying to write a script which takes backup of each database and immediately delete it.. The script should delete the old backup of the database immediately after the new backup is taken... For eg:
declare cursor bkup select name from sysdatabases
open bkup
......
...
......
xp_backup_database @dbname .................
delete old backup files
.........
fetch next from bkup
......
Thanks for your help!!!!