Other versions are also available for the following:
SQL Server 2008 Books Online (October 2009)
Creating Full and Differential Backups of a SQL Server Database
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.
See Also