Hands-On Microsoft SQL Server™ 2005 Integration Services

Shrink Database Task

This task runs the DBCC SHRINKDATABASE T-SQL command to shrink the specified database. The step by step configuration process goes like this:

1.	Drag the task on the Designer panel and start configuring this task. First connect to the SQL Server. This task uses the ADO.Net Connection Manager to create connection to the server. Choose the databases from the option list: All databases, All system databases (master, msdb, model), All user databases (excluding master, msdb, model and tempdb) or select databases from the provided list.
2.	After selecting the database, specify when you want this task to execute by typing in the size in megabytes in the Shrink database when it grows beyond option.
3.	Specify how much free space you ...