• 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!!!!