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: Friday, October 17, 2014 12:24 PM
Points: 5,584, Visits: 6,376
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: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
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: Tuesday, October 14, 2014 4:43 AM
Points: 1,130, Visits: 1,391
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: Today @ 2:18 AM
Points: 1,602, Visits: 5,651
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: Yesterday @ 10:29 AM
Points: 1,880, Visits: 3,460
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: Tuesday, September 16, 2014 9:47 AM
Points: 357, Visits: 914
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: Tuesday, October 7, 2014 2:36 PM
Points: 2,818, Visits: 2,565
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: Friday, October 17, 2014 12:24 PM
Points: 5,584, Visits: 6,376
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 3:06 PM
Points: 17,805, Visits: 15,716
Thanks for the question Brandie.



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


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1001530
Posted Sunday, October 10, 2010 4:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:12 AM
Points: 7,791, Visits: 9,545
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