• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 367
  • Last Modified:

SQL Server 2008 - What is incremental backups in SQL2K8?

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
JElster
Asked:
JElster
1 Solution
 
Steve WalesSenior Database AdministratorCommented:
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

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now