How SQL server will identify the transactions which are happened after full backup?

  • Hi,

    Ex :

    My backup strategy is like the following

    every 24 h full backup,

    every 3h differential backup

    every 1h log backup.

    I have a question i.e

    i have taken the full backup and inserted 100 transactions ,

    How sql server will identify those 100 transactions should comes under the differential backup.

    🙂

    Regards
    Chowdary...

  • The transactions after the full backup would have flipped the relevant bits in the Differential Change Map, flagging the affected extents as ones which need to be included in differential backups

    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
  • Thank you Gail Shaw,

    Is there any article on that topic , Because as am having less hands on exp on that.

    Regards
    Chowdary...

  • Should be some in Books Online. Have a read through the docs on full, diff and log backups and how they work.

    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

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

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