Post reply

Restore DB with Full and T-log vs. Full, T-log and Differentail

  • February 1, 2016 at 2:48 pm

    #324465

    Hi,

    I have my database in Full Recovery Mode, I am taking just Full backup(everyday at 9 PM) and T-log every 15 minutes, if the database were to crash at 1:20 am, how much data loss will I be facing?

    Second scenario, Full backup every at 10 PM, Differential every 6 hours and T-log every 15 mins, database crashes at 1 :20 am, how much data loss will I be facing in this case?

    Thank you in advance.

  • February 1, 2016 at 3:03 pm

    #1855855

    Both scenarios, either 5 minutes or 0 minutes, depending whether you can back up the tail of the log or not.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 1, 2016 at 3:09 pm

    #1855859

    For First Scenario:

    Restore Full Backup done at 9 Pm followed by T-logs till 1:15AM

    For Second Scenario:

    It would be the same?

  • February 1, 2016 at 3:19 pm

    #1855863

    You can, it'll work fine.

    Or, if there was a differential backup at midnight, you could restore the 9pm full, the midnight diff and the logs until 1:15

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 1, 2016 at 3:25 pm

    #1855865

    Thanks

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

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