Post reply

Incremental Back up

  • February 3, 2012 at 4:07 am

    #251014

    Is there thing like incremental back up in sql server 2008? how to take an incremental backup?

    Regards,

    Snigdha

  • February 3, 2012 at 4:13 am

    #1442286

    No. SQL's backups are full, differential and log.

    Some people call log backups incremental, but they are not truly incremental 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

  • February 3, 2012 at 4:29 am

    #1442301

    Thanks Gail...

    Regards,

    Snigdha

  • February 3, 2012 at 8:21 pm

    #1442711

    Hi,

    I think Differential backups are called as incremental backups. Because it is incremented (First+Second=Third) every time in size and data. Log backups just takes the transactions. It can be less or more.

    Thanks,

    Rajeev Ramachandran

  • February 4, 2012 at 12:24 am

    #1442721

    Rajeev Ramachandran (2/3/2012)

    I think Differential backups are called as incremental backups.

    Differential and incremental are very different things.

    Differential is what we have in SQL, where all differential backups depend on the last full backup, so you only restore the latest. Incremental backups depend on the last full, differential or incremental (they were used in NTBackup), so you'd have to restore all of them in sequence (like log backups, but incrementals can't be used for STOPAT or similar)

    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 5 posts - 1 through 4 (of 4 total)

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