Solved

SQL Server 2008  - What is incremental backups in SQL2K8?

Posted on 2013-01-23
1
348 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
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…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

895 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now