Difference Between Incremental Backup and Sequential Backup?

  • Hi All,

    Can anyone explain the difference between Incremental Backup and Sequential Backup ...

    Regards

    Jagadeesh...

    Regards
    Chowdary...

  • Neither of those backup types exist in SQL server. You have Full, Differential and Transaction Log backups only.

    An incremental backup would be a Windows based file backup that only backs up changes since the last backup.

    Sequential.. no idea, never heard of it.

  • Chowdary's (8/17/2014)


    Hi All,

    Can anyone explain the difference between Incremental Backup and Sequential Backup ...

    Regards

    Jagadeesh...

    In SQL there is no such thing like Incremental Backup ,but have that in Oracle in which it contains changes from the last incremental to the time taken.

  • Chowdary's (8/17/2014)


    Can anyone explain the difference between Incremental Backup and Sequential Backup ...

    In what context did you encounter those terms? Neither is a SQL Server term.

    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
  • After a couple of searches, the only database system that I can find that has a "sequential backup" is MyBB. Here's a forum for that [/url]if that's what you're looking for. Other than that, I'm with everyone else, those are not terms applicable to SQL Server.

    "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

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

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