Click to Rate and Give Feedback

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (0)
SQL Server 2005 Books Online (November 2008)
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.

Topic Description

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.

Copy-Only Backups

Describes copy-only backups. Copy-only backups are isolated backups that are intended as special-purpose additions to regularly scheduled conventional backups.

ms190412.note(en-US,SQL.90).gifNote:
For information about how to schedule backup jobs for a database, see Maintenance Plan Wizard.

Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker