Back Up Database Task

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

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.

Supported Recover Models and Backup Types

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

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

Configuration of 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:

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

Integration Services icon (small) 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:


For automatic notification of these updates, subscribe to the RSS feeds available on the page.