<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
Books
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
Incremental backup
11 posts, Page 1 of 2
1
2
»»
Incremental backup
Rate Topic
Display Mode
Topic Options
Author
Message
ananda.murugesan
ananda.murugesan
Posted Monday, September 29, 2008 5:07 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, May 22, 2009 4:06 AM
Points: 165,
Visits: 522
hi sqldba,
pls tell me, what is the different between incremental backup and differential backup in sql server 200?
Post #577625
Dugi
Dugi
Posted Monday, September 29, 2008 5:48 AM
SSC Eights!
Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 847,
Visits: 1,932
....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
============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #577640
Greg Charles
Greg Charles
Posted Monday, September 29, 2008 9:56 AM
Hall of Fame
Group: General Forum Members
Last Login: Thursday, July 02, 2009 4:39 PM
Points: 3,365,
Visits: 2,397
Depends on your definition of incremental backup. A differential backup backs up extents modified since the last full backup.
Greg
Post #577827
GilaMonster
GilaMonster
Posted Monday, September 29, 2008 2:08 PM
SSChampion
Group: General Forum Members
Last Login: Today @ 1:26 PM
Points: 12,626,
Visits: 8,658
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
We walk in the dark places no others will enter
We stand on the bridge and none may pass
Post #577972
Dugi
Dugi
Posted Wednesday, October 01, 2008 1:56 PM
SSC Eights!
Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 847,
Visits: 1,932
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
============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #579361
ang
ang
Posted Thursday, October 02, 2008 2:06 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, May 15, 2009 10:20 AM
Points: 80,
Visits: 282
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?
Post #579934
Jeffrey Williams
Jeffrey Williams
Posted Thursday, October 02, 2008 2:20 PM
SSCrazy
Group: General Forum Members
Last Login: Today @ 11:40 AM
Points: 2,071,
Visits: 3,429
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
Problems are opportunites brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
Post #579941
ang
ang
Posted Thursday, October 02, 2008 2:34 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, May 15, 2009 10:20 AM
Points: 80,
Visits: 282
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)
Post #579951
Greg Charles
Greg Charles
Posted Thursday, October 02, 2008 2:43 PM
Hall of Fame
Group: General Forum Members
Last Login: Thursday, July 02, 2009 4:39 PM
Points: 3,365,
Visits: 2,397
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
Post #579955
ang
ang
Posted Thursday, October 02, 2008 3:23 PM
SSC Journeyman
Group: General Forum Members
Last Login: Friday, May 15, 2009 10:20 AM
Points: 80,
Visits: 282
Oh, ok. I see the difference now!
Thanks.
Post #579970
« Prev Topic
|
Next Topic »
11 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
may
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
