• Functionally, I don't see any major difference between the two. Seriously. However, since we're dealing with human beings, I agree with you. Never over-write an existing back-up, using a single backup per file, name the backup files meaningfully so that you can find them later and understand what they are (usually this entails using a date as well as the db name)... All very good practices to prevent human beings (or me) from screwing up.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning