| title | Back Up Database Task | Microsoft Docs | |||||
|---|---|---|---|---|---|---|
| ms.custom | ||||||
| ms.date | 06/13/2017 | |||||
| ms.prod | sql-server-2014 | |||||
| ms.reviewer | ||||||
| ms.technology | integration-services | |||||
| ms.topic | conceptual | |||||
| f1_keywords |
|
|||||
| helpviewer_keywords |
|
|||||
| ms.assetid | b8839d71-13b7-41f2-a434-cb95020e79d7 | |||||
| author | janinezhang | |||||
| ms.author | janinez | |||||
| manager | craigg |
The Back Up Database task performs different types of [!INCLUDEssNoVersion] 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.
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).
You can set properties through [!INCLUDEssIS] Designer. This task is in the Maintenance Plan Tasks section of the Toolbox in [!INCLUDEssIS] Designer.
For more information about the properties that you can set in [!INCLUDEssIS] Designer, click the following topic:
For more information about how to set these properties in [!INCLUDEssIS] Designer, click the following topic: