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 1 of 2
12»»

Backup Types Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Brandie Tarvin
Posted Thursday, October 07, 2010 9:50 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 6,668, Visits: 5,695
Comments posted to this topic are about the item Backup Types

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 #1001000
UMG Developer
Posted Thursday, October 07, 2010 9:50 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163, Visits: 2,148
Nice question, thanks!
Post #1001001
Hardy21
Posted Thursday, October 07, 2010 10:06 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: Wednesday, May 22, 2013 7:11 AM
Points: 877, Visits: 1,159
Nice question "Brandie Tarvin". Incremental is in Windows backup types & Differential is in SQL Backup types so its a googly ball

Thanks
Post #1001008
paul.knibbs
Posted Friday, October 08, 2010 1:12 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:27 AM
Points: 1,259, Visits: 4,260
Interesting. I've never heard of a partial backup, and am struggling to figure out how it would be useful...will have to do some research!
Post #1001043
Nils Gustav Stråbø
Posted Friday, October 08, 2010 2:27 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 8:52 AM
Points: 1,788, Visits: 3,327
Good question. I answered it wrong even though I knew the correct answer. What fooled me was the incremental backup. I know there is nothing called an incremental backup, but I have also seen that transaction log backups sometimes are referred to as a kind of incremental backup, so I though "is this a trick question?". Lesson learned: always trust my initial instinct.
Post #1001069
NickBalaam
Posted Friday, October 08, 2010 5:42 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, March 12, 2013 7:27 AM
Points: 342, Visits: 788
Partial Backup caught me out on this one, had the others. So there's a "learning opportunity" for me.
Post #1001187
Daniel Bowlin
Posted Friday, October 08, 2010 7:01 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:10 PM
Points: 2,673, Visits: 2,418
Argh! (Is it talk like a pirate day?)
Too much time as a windows admin, incremental backup. Partial backup is a new one on me. Good question, thanks.
Post #1001253
Brandie Tarvin
Posted Friday, October 08, 2010 12:03 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 6,668, Visits: 5,695
I'm glad the question has helped so many people. I did not realize how few people knew about File and Partial backups.

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 #1001495
SQLRNNR
Posted Friday, October 08, 2010 12:29 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 10:25 AM
Points: 18,754, Visits: 12,337
Thanks for the question Brandie.


Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1001530
L' Eomot Inversé
Posted Sunday, October 10, 2010 4:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:54 AM
Points: 7,112, Visits: 7,188
Nice question as far as it goes.

But it would have been nice to go a bit further and have a few more backup types, a list like

Database backup
Differential database backup
Partial backup
Differential partial backup
File backup
Differential file backup
Log backup
(plus of course incremental backup and maybe more spurious ones)

so that it's clear that the Database/Partial/File distinction is orthogonal to the Full/Differential distinction, giving 6 possibilities plus the log backup to make 7.

And then does WITH Copy Only introduce some more types and if so how many - but maybe that could be a separate QotD.

Tom
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.
Post #1001802
« Prev Topic | Next Topic »

Add to briefcase
18 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

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