September 29, 2008 at 5:07 am
hi sqldba,
pls tell me, what is the different between incremental backup and differential backup in sql server 200?
September 29, 2008 at 5:48 am
....hahaha SQL Server 200 never exist (little joke) anyway...
there is the link with lot of information that you can find about backup and restore!
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx
Hope it helps you!
Dugi
:w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t:
September 29, 2008 at 9:56 am
Depends on your definition of incremental backup. A differential backup backs up extents modified since the last full backup.
Greg
September 29, 2008 at 2:08 pm
ananda.murugesan (9/29/2008)
hi sqldba,pls tell me, what is the different between incremental backup and differential backup in sql server 200?
SQL doesn't have an incremental backup. It has a full backup, a differential backup and a log backup.
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
October 1, 2008 at 1:56 pm
GilaMonster (9/29/2008)
ananda.murugesan (9/29/2008)
hi sqldba,pls tell me, what is the different between incremental backup and differential backup in sql server 200?
SQL doesn't have an incremental backup. It has a full backup, a differential backup and a log backup.
...But interesting also I had the experience in an interview with one Senior DBA (maybe) and he asked me what is the differences between Incremental Backup and Transactiona Backup! And finally I didn't find the any answer couz I didn't read anywhere for that kind of Backup so...Why this Senior DBA asked me about incremental bakcup !? - LOL
:w00t:
October 2, 2008 at 2:06 pm
That's a good question! I thought I knew the answer to it, but I think not?
transaction log backup - backs up the transaction log (which holds transactions since the last backup)
differential backup - backs up data that has changed since the last full backup (data since the last backup)
So really, my answer is the same for both...backs up data since the last backup??? Is this correct, just 2 ways to do something?
October 2, 2008 at 2:20 pm
You can find references to incremental backups for SQL Server in the SMO documentation. From there, an incremental backup is equivelant to a differential backup in SQL Server.
Using SMO - you set the incremental property to define and perform a differential backup.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 2, 2008 at 2:34 pm
I'm trying to determine the difference between a differential backup and a transaction log backup (as stated previously, SS only has differential, not incremental)
October 2, 2008 at 2:43 pm
Ang,
I think you almost answered your own question. A differential backup backs up changes since the last full backup while a transaction log backup backs up changes since the last transaction log backup.
Greg
October 2, 2008 at 3:23 pm
Oh, ok. I see the difference now!
Thanks.
October 3, 2008 at 1:31 am
To be a little pedantic...
Transaction log backups don't backup changes. They backup a list of operations that occurred since the last log backup, including the time that they occurred. If they just backed up data changes, like differential backups do, then it would not be possible to apply part of a log backup (using stop at)
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
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply