Post reply

tran log backup confused 2.5gb log file but 70gb log backup size

  • September 6, 2012 at 12:55 pm

    #1534712

    We don't use the snaps as a backup method. It is strictly for rollback purposes if an update messes up.

    I have yet to ever have to roll a snapshot back.

  • September 6, 2012 at 1:17 pm

    #1534724

    In that case consider switching to SIMPLE recovery before your maintenance then back to FULL after. Take a FULL backup immediately after switching back to FULL recovery to re-establish a log chain and continue taking log backups per the usual schedule.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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