This topic has not yet been rated - Rate this topic

Creating Full and Differential Backups of a SQL Server Database

SQL Server 2008 R2

Creating the correct backups is essential to a successful backup-and-restore strategy. The topics in this section describe how to create the various types of data and differential backups.

In This Section

Full Database Backups: Describes how to use full database backups and differential database backups.
Partial Backups: Describes how to use partial backups and differential partial backups.
Full File Backups: Describes how to use file backups and differential file backups.
Using Differential Backups: Describes the restrictions on using differential backups under the simple recovery model, the backup upon which a differential backup is based, and the conditions under which a file that is created after the differential base is included in new differential backups.
Backing Up Read-Only Databases: Describes partial backups after changing a database to read-write access and differential backups of a read-only database.