Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Brandie Tarvin » Backup Types
Add to briefcase
18 posts, Page 2 of 2
««12

Backup Types Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Hardy21
Posted Sunday, October 10, 2010 10:16 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:11 AM
Points: 877, Visits: 1,159
Thanks Tom Thomson for all backup types.

Thanks
Post #1001903
sbamaty
Posted Friday, October 15, 2010 10:04 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 11:03 AM
Points: 628, Visits: 102
I have never used Incremental backup but I kind of remember reading somewhere about it as a new addition to SQL 2005 when it first came out. I never went back to dig into it as I care much less about this new backup feature as I was not going to use it anytime soon but it was somewhere in the back of my head that it is there if I happen to need it in future.

I read somewhere on online posting, long time ago that Incremental Backup backs up database since the last full backup and the last incremental backup whereas Differential Backup backs up database since the last full backup.
Post #1005330
Brandie Tarvin
Posted Friday, October 15, 2010 10:19 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:45 AM
Points: 6,657, Visits: 5,680
JustStarted (10/15/2010)
I read somewhere on online posting, long time ago that Incremental Backup backs up database since the last full backup and the last incremental backup whereas Differential Backup backs up database since the last full backup.


Nope. Sorry. Lots of people call Transaction Logs by the name Incremental, which unfortunately persists the myth. It's a bad name to call it since Incremental really does exist for other software products.

EDIT: Just a note. Transaction Logs do not behave the way you've listed Incrementals as behaving. It's similar behavior, but you need every Transaction Log up to the most current or your P.I.T. in order to properly restore the database.

Incremental just doesn't exist for SQL Server. See my SQL Misconceptions post for T-SQL Tuesday this month.

Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1005344
Dhruvesh Shah
Posted Tuesday, October 19, 2010 1:08 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, July 25, 2012 9:04 PM
Points: 542, Visits: 187
Nice Question. logged back after a long time and got it wrong.
Post #1006741
sharath.chalamgari
Posted Wednesday, October 20, 2010 12:14 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 17, 2012 7:30 AM
Points: 1,038, Visits: 679
I guess incremental Back up was there only in oracle :)
Post #1007477
Jamie Longstreet-481950
Posted Thursday, December 09, 2010 6:57 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:48 AM
Points: 2,440, Visits: 714
Strange... backing up files in Diff format... never knew.

Jamie
Post #1032435
SQL Writer
Posted Wednesday, December 15, 2010 5:18 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, August 28, 2012 4:29 AM
Points: 688, Visits: 311
I don't know about partial backup .can any guys help me?
Post #1035035
Brandie Tarvin
Posted Wednesday, December 15, 2010 5:28 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:45 AM
Points: 6,657, Visits: 5,680
What do you want to know?

The easiest way to learn the basics is to look up Partial Backup in Books Online. But if you've already done that and have specific questions, feel free to ask.

Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.
Post #1035046
« Prev Topic | Next Topic »

Add to briefcase
18 posts, Page 2 of 2
««12

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.