SQLServerCentral / Discuss Content Posted by Brandie Tarvin / Article Discussions / Article Discussions by Author / Backup Types / Latest Posts

RE: Backup Types

Brandie Tarvin — Wed, 15 Dec 2010 05:28:05 GMT

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.

RE: Backup Types

SQL Writer — Wed, 15 Dec 2010 05:18:46 GMT

I don't know about partial backup .can any guys help me?

RE: Backup Types

Jamie Longstreet-481950 — Thu, 09 Dec 2010 06:57:48 GMT

Strange... backing up files in Diff format... never knew.

RE: Backup Types

sharath.chalamgari — Wed, 20 Oct 2010 00:14:25 GMT

I guess incremental Back up was there only in oracle :)

RE: Backup Types

Dhruvesh Shah — Tue, 19 Oct 2010 01:08:33 GMT

Nice Question. logged back after a long time and got it wrong. :sick:

RE: Backup Types

Brandie Tarvin — Fri, 15 Oct 2010 10:19:37 GMT

[quote][b]JustStarted (10/15/2010)[/b][hr]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.[/quote]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 [url=http://brandietarvin.livejournal.com/22020.html]SQL Misconceptions post [/url]for T-SQL Tuesday this month.

RE: Backup Types

sbamaty — Fri, 15 Oct 2010 10:04:51 GMT

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.

RE: Backup Types

Hardy21 — Sun, 10 Oct 2010 22:16:03 GMT

Thanks Tom Thomson for all backup types.

RE: Backup Types

L' Eomot Inversé — Sun, 10 Oct 2010 04:56:38 GMT

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 likeDatabase backupDifferential database backupPartial backupDifferential partial backupFile backupDifferential file backupLog 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.

RE: Backup Types

SQLRNNR — Fri, 08 Oct 2010 12:29:57 GMT

Thanks for the question Brandie.

RE: Backup Types

Brandie Tarvin — Fri, 08 Oct 2010 12:03:31 GMT

I'm glad the question has helped so many people. I did not realize how few people knew about File and Partial backups.

RE: Backup Types

Daniel Bowlin — Fri, 08 Oct 2010 07:01:53 GMT

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.

RE: Backup Types

NickBalaam — Fri, 08 Oct 2010 05:42:41 GMT

Partial Backup caught me out on this one, had the others. So there's a "learning opportunity" for me. ;-)

RE: Backup Types

Nils Gustav Stråbø — Fri, 08 Oct 2010 02:27:36 GMT

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.

RE: Backup Types

paul.knibbs — Fri, 08 Oct 2010 01:12:43 GMT

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!

RE: Backup Types

Hardy21 — Thu, 07 Oct 2010 22:06:53 GMT

Nice question "Brandie Tarvin". Incremental is in Windows backup types & Differential is in SQL Backup types so its a googly ball :-)

RE: Backup Types

UMG Developer — Thu, 07 Oct 2010 21:50:37 GMT

Nice question, thanks!

Backup Types

Brandie Tarvin — Thu, 07 Oct 2010 21:50:02 GMT

Comments posted to this topic are about the item [B]Backup Types[/B]