Home Forums SQL Server 2005 Backups Backup and transaction log RE: Backup and transaction log

  • May 8, 2009 at 4:12 am

    #990963

    sumanta.roy52 (5/8/2009)

    Hi,

    What does differential backup capture? I mean does it take the changes from last full backup/last differential backup.

    Last full backup. So if you have a full on Sunday, a diff on Monday, Tuesday and Wednesday, to restore to Thursday morning you need the sunday full, just the Wednesday diff and then the log backups from there aon.

    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