August 17, 2014 at 11:58 pm
Hi All,
Can anyone explain the difference between Incremental Backup and Sequential Backup ...
Regards
Jagadeesh...
Regards
Chowdary...
August 18, 2014 at 12:24 am
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.
August 18, 2014 at 1:02 am
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.
August 18, 2014 at 2:33 am
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
August 18, 2014 at 6:05 am
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