• In your backup command you use the option NOINIT. This instructs the server not to overwrite the backup file, so each day you keep the old backups and then you add the new backup. If you'll change the command and instead on NOINIT you'll specify INIT, it will overwrite the backup on a daily bases instead of adding the new backup to the old one.

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/