incremental backup

  • Can anybody brief about incremental backup? when it will be used?

  • SQL Server doesn't have incremental backups.

    It has full database backups, differential database backups and log backups. Which are you asking about?

    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
  • The differential backup will be used only if you specify it yourself for backups. It won't automatically run unless you set it up. The differential will only backup changes to the database since the last full backup, making it a faster option on systems with a high load. But, it makes recovery longer because you have to restore the full backup and the differential. If you do use differentials, make sure you still take full backups regularly and don't lose those because the differentials depend on it.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Dear Shreekant,

    SQL Server has following 3 types of backup:

    1.Full backup

    2.Differential backup

    3.Transaction log backup

    Full backup takes backup of complete data and log file upto that time.

    Differential backup takes backup of all data changes since the last full backup.

    Transaction log backup works in the form of a continuous chain. After full backup transaction log backups can be scheduled such that they form a continuous chain.

    Probably when you say incremental you meant Differential.. 🙂

    Regards

    Shafat Husain

    Regards,
    Shafat Husain
    🙂
    And Your Lord Never Forgets...!! (64:19 -- Quran)

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

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