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
Comments
Post a Comment
Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You