Post reply

Backing up Transcation Log Files

  • July 22, 2009 at 4:13 pm

    #208623

    Hello,

    If I have file size restrictions on the Transacation Log File (LDF), and I do a backup creating the TRN, do I get all of the transactions? I am thinking, if the LDF does not hold everything because of the size, do I get everything during the backup?

    Thank you,

    Paul

  • July 22, 2009 at 7:00 pm

    #1028726

    Performing a transaction log backup in the full recovery model truncates the log, allowing the space to be reused for new transacions. You will "get everything" in your log backup because if your transaction log fills up (to the point where your space limitations prevent it from growing) before you get around to backing it up/truncating, your database will not accept any inserts/updates/deletes or anything that gets logged for that matter.

Viewing 2 posts - 1 through 1 (of 1 total)

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