• From the article:


    I know that some people like having the same filename every day as it makes restores simpler, especially if they've scripted things.

    I realize this is a 4 year old article but backups are the second most important thing there is in SQL server.

    Not to be confused with "simple" and as Granny used to say, "I've found that people that take certain shortcuts frequently get mud in their shoes". 😉 If someone takes a "shortcut" on backups, they get what the deserve... failed restores.

    So, no... I don't believe that you have a jaded or out of date opinion on this... even 4 years later.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)