Post reply

Differential backup.

  • June 14, 2012 at 2:25 am

    #258067

    hi,

    Can anyone let me know please....

    I have a full database backup running on the server at 1 am. Diff bkp job is running in every 4 hrs, run intervals : 5 am, 9 am, ...

    when the 5 am diff bkp job runs and when the next diff bkp runs by 9 am, will the 9 am bkp contain the details after the 1 am full database backup all the details or after the diff bkpo which ran by 5 am?

    Thanks.

  • June 14, 2012 at 2:34 am

    #1500830

    It will contain all changes since the Full backup

    So, If you backup FULL at 1am, then DIFF at 5am, 9am, 1pm, 5pm, 9pm.

    To restore at 7pm, you need Full at 1am, Diff from 5pm, plus any TX logs between 5pm and 7pm

  • June 14, 2012 at 3:36 am

    #1500858

    Hello,

    will the log backup clear the log once backup done and will the intermediate log backup affect diff backup?

    Regards
    Durai Nagarajan

  • June 14, 2012 at 3:44 am

    #1500863

    Performing a log backup will make the log as re-usable, allowing the already allocated space to be re-used.

    Log backups do not affect the differential backup.

  • August 16, 2012 at 2:27 am

    #1526389

    🙂

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

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