Back up Database Task

The back up database task performs different types of sql server database backups. 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

Step 1:

Drag and drop Back up database task in control flow and edit it.

Step 2:

Give a new connection as BackUp.

Step 3:

Select a database to given databases.

Step 4:

Add new  backup destination and give backup file path location as

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\Backup\BALU

Step 5:

Click on view T-SQL to view  a query.

Step 6:

Execute a task