Post reply

Do we need a Full backup if we are not backing up the transaction log?

  • July 25, 2012 at 5:20 pm

    #278544

    Pretty basic question. Do we?

    ===============================================================

    "lets do amazing" our company motto..

  • July 25, 2012 at 5:39 pm

    #1517693

    Yes. Find out how much data/time your company can afford to lose and take full backups within that window. Without a backup you can lose ALL your data if the DB becomes corrupt or the disk fails.

    And then again, I might be wrong ...
    David Webb

  • July 25, 2012 at 5:47 pm

    #1517694

    Thanks for your response!

    but im referring to the backup Options FULL, SIMPLE and Bulk log. Sorry for the confusion.

    ===============================================================

    "lets do amazing" our company motto..

  • July 25, 2012 at 6:02 pm

    #1517698

    jnuqui (7/25/2012)

    Thanks for your response!

    but im referring to the backup Options FULL, SIMPLE and Bulk log. Sorry for the confusion.

    Those are "Recovery Mode" options. The answer to your question is that if you're not going to do transaction log backups, then you should use the SIMPLE mode which truncates (not shrinks) the transaction log automatically when a transaction is committed.

    --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)

  • July 25, 2012 at 6:15 pm

    #1517703

    thanks for the response! 🙂

    ===============================================================

    "lets do amazing" our company motto..

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply