• I strongly recommend NOT appending backups to the same file. Makes it really easy to lose all your backups instead of one.
    Each one to its own file, preferably with the datetime as part of the file name

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass