| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Check Database Integrity Task |
Check Database Integrity Task |
chugugrace |
chugu |
03/04/2017 |
sql |
integration-services |
conceptual |
|
|
[!INCLUDEsqlserver-ssis]
The Check Database Integrity task checks the allocation and structural integrity of all the objects in the specified database. The task can check a single database or multiple databases, and you can choose whether to also check the database indexes.
The Check Database Integrity task encapsulates the DBCC CHECKDB statement. For more information, see DBCC CHECKDB (Transact-SQL).
You can set properties through [!INCLUDEssIS] Designer. This task is in the Maintenance Plan Tasks section of the Toolbox in [!INCLUDEssIS] Designer.
For more information about the properties that you can set in [!INCLUDEssIS] Designer, click the following topic:
For more information about how to set these properties in [!INCLUDEssIS] Designer, click the following topic: