Back Up Database Task

The Back Up Database task performs different types of SQL Server database backups. For more information, see Backing Up and Restoring Databases in SQL Server.

By using the Back Up Database task, a package can back up a single database or multiple databases. If the task backs up only a single database, you can choose the backup component: the database, or its files and filegroups.

The following table lists the recovery models and backup types that the Back Up Database task supports.

Recovery model	Database	Database differential	Transaction log	File or file differential
Simple	Required	Optional	Not supported	Not supported
Full	Required	Optional	Required	Optional
Bulk-logged	Required	Optional	Required	Optional

For more information about backup types, see Backup Under the Full Recovery Model and Backup Under the Simple Recovery Model.

The Back Up Database task encapsulates a Transact-SQL BACKUP statement. For more information, see BACKUP (Transact-SQL).

Configuring the Back Up Database Task

You can set properties through SSIS Designer. This task is in the Maintenance Plan Tasks section of the Toolbox in SSIS Designer.

For more information about the properties that you can set in SSIS Designer, click the following topic:

• Back Up Database Task (Maintenance Plan)

For more information about how to set these properties in SSIS Designer, click the following topic:

• How to: Set the Properties of a Task or Container

Stay Up to Date with Integration Services For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet: Visit the Integration Services page on MSDN Visit the Integration Services page on TechNet For automatic notification of these updates, subscribe to the RSS feeds available on the page.

See Also

Concepts

Maintenance Tasks

Integration Services Tasks

Creating Package Control Flow