Back Up Database Task
The Back Up Database task uses the BACKUP DATABASE statement to perform different types of SQL Server database backups. Using the Back Up Database task, a package can back up a single database or multiple databases. Following is the step by step method to configure this task:
1. | Specify a connection to the SQL Server using the ADO.Net Connection Manager in the Connection field.
Choose the databases you want to back up in the Databases field from the available options: All databases, All system databases (master, msdb, model), All user databases (excluding master, msdb, model and tempdb) or selected databases from the provided list. |
2. | Specify the Backup type by selecting from the available options of Full, Differential, ... |
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
