• Use INIT option in the WITH clause of backup statement, it will overwrite the existing backup file. for more info try this link

    http://msdn.microsoft.com/en-us/library/ms186865.aspx

    Nag.

    Nag
    ------------------------------------------------
    How to get the best help on a forum

    http://www.sqlservercentral.com/articles/Best+Practices/61537