Check Database Integrity Task

The Check Database Integrity task uses DBCC CHECKDB statement to check the allocation and structural integrity of all the objects in the specified databases.

The task is simple to configure:

  1. Drag and drop this task on the Designer panel and start editing, and then specify a connection to the SQL Server using the ADO.Net Connection Manager.

    Choose the databases from Databases field. When you click the down arrow in the field, following list of options appear:

    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. You can choose either single database or multiple databases—Figure 5-32 shows all the user databases ...

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.