Solved

SQL Server 2008  - What is incremental backups in SQL2K8?

Posted on 2013-01-23
1
350 Views
Last Modified: 2013-01-23
is appending to the existing backup an incremental backup?

How can I backup daily to a single file and revert to a given day?
0
Comment
Question by:JElster
1 Comment
 
LVL 22

Accepted Solution

by:
Steve Wales earned 295 total points
ID: 38810630
No, appending to an existing backup is not an incremental backup.

I could go into detail here, but the types of backups and examples of how they work are well covered in the documentation.

I would suggest you read the following:
Backup Overview: http://msdn.microsoft.com/en-us/library/ms175477.aspx
Full Database Backups: http://msdn.microsoft.com/en-us/library/ms186289.aspx
Backup and Restore of SQL Server Databases: http://msdn.microsoft.com/en-us/library/ms187048.aspx
Transaction Log Backups: http://msdn.microsoft.com/en-us/library/ms191429.aspx

The type of backup has nothing to do with the file you back up the database to.  The type of backup is based upon how you backup that database.

A full database backs up the whole database
An incremental backup takes a backup of changes since the last full database backup

If you want to get down to the nitty gritty, there is no concept of a differential backup in SQL Server.  The closest thing to it would be transaction log backups.

So, in brief, we have:

Full: Complete backup
Incremental: Changes since last full
Transaction Log: Changes recorded in the transaction log since last transaction log backup
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Ssis not sending failure message 2 26
MSSQL Speen Degradation 4 23
SQL Server 2012 r2 - Sum totals 2 25
SQL Insert parts by customer 12 34
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question