Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Backup Types Expand / Collapse
Author
Message
Posted Thursday, October 7, 2010 9:50 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 9:11 AM
Points: 7,128, Visits: 6,291
Comments posted to this topic are about the item Backup Types

Brandie Tarvin, MCITP Database Administrator

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
Posted Thursday, October 7, 2010 9:50 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 16, 2014 9:38 AM
Points: 2,163, Visits: 2,189
Nice question, thanks!
Post #1001001
Posted Thursday, October 7, 2010 10:06 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 6:54 AM
Points: 1,032, Visits: 1,295
Nice question "Brandie Tarvin". Incremental is in Windows backup types & Differential is in SQL Backup types so its a googly ball

Thanks
Post #1001008
Posted Friday, October 8, 2010 1:12 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 25, 2014 3:12 AM
Points: 1,610, Visits: 5,482
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
Posted Friday, October 8, 2010 2:27 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, June 6, 2014 7:58 AM
Points: 1,837, Visits: 3,420
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
Posted Friday, October 8, 2010 5:42 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 21, 2014 8:31 AM
Points: 357, Visits: 909
Partial Backup caught me out on this one, had the others. So there's a "learning opportunity" for me.
Post #1001187
Posted Friday, October 8, 2010 7:01 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:41 AM
Points: 2,818, Visits: 2,553
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
Posted Friday, October 8, 2010 12:03 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 9:11 AM
Points: 7,128, Visits: 6,291
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

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
Posted Friday, October 8, 2010 12:29 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:15 PM
Points: 21,229, Visits: 14,935
Thanks for the question Brandie.



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


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
Posted Sunday, October 10, 2010 4:56 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:44 PM
Points: 8,562, Visits: 9,062
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
Post #1001802
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse