Post reply

Backup

  • November 20, 2015 at 8:04 pm

    #399363

    Good Morning Experts,

    Backup completes at time t1. Exactly at time t1, a transaction A starts. Will the backup contain this transaction A?

  • November 20, 2015 at 10:28 pm

    #1841494

    coolchaitu (11/20/2015)

    Good Morning Experts,

    Backup completes at time t1. Exactly at time t1, a transaction A starts. Will the backup contain this transaction A?

    It is a depends answer but the likelihood of it being there is low. You can read through this article from Paul Randal on how to tell if a transaction is in your backup[/url].

    In that article Paul lays out how a full backup works:

    1) Note the transaction log’s LSN (Log Sequence Number)

    2) Read all allocated extents in the various data files

    3) Note the LSN again

    4) Read all the transaction log between the starting LSN and the ending LSN

    Being that your transaction starts right when the backup is finishing it has already gone through the data-reading portion of the backup (step 2) so your transaction would more than likely not be included.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • November 21, 2015 at 12:03 am

    #1841500

    if your backup completes at t1 then no , if your backup started at t1 then yes

    Jayanth Kurup[/url]

  • November 21, 2015 at 12:10 am

    #1841501

    Thanks Shawn and Jayanth.

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

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