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:
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.