Online Documentation for SQL Manager for SQL server
Specifying arguments and options
Use this step of the wizard to specify arguments and options for the check database operation.
Disable intensive checks of nonclustered indexes for user tables
This argument (NOINDEX) specifies that intensive checks of non-clustered indexes for user tables should not be performed; therefore, the overall execution time is decreased.
Repair with data loss
When this argument (REPAIR_ALLOW_DATA_LOSS) is used, all reported errors are repaired. These repairs can cause data loss.
This argument (REPAIR_FAST) enables fast repair of errors which is maintained for backward compatibility.
Repair and rebuild indexes
This argument (REPAIR_REBUILD) performs all repairs performed by REPAIR_FAST and includes time-consuming repairs such as rebuilding indexes. These repairs can be performed without risk of data loss.
This option (ALL_ERRORMSGS) displays an unlimited number of errors per object.
No info messages
This option (NO_INFOMSGS) suppresses all informational messages.
Use exclusive database lock
If this option (TABLOCK) is used, the DBCC CHECKDB statement obtains locks instead of using an internal database snapshot. This includes a short-term database exclusive lock.
This option (ESTIMATEONLY) displays the estimated amount of tempdb space that is required to run DBCC CHECKDB with all the other specified options. The actual database check is not performed in this case.
This option (PHYSICAL_ONLY) limits the checking operation to the integrity of the physical structure of the page and record headers, the physical structure of B-trees and the allocation consistency of the database. Designed to provide a small overhead check of the physical consistency of the database, this check can also detect torn pages, checksum failures, and common hardware failures that can compromise a user's data.
Purity of data
If this option (DATA_PURITY) is enabled, the DBCC CHECKDB statement checks the database for column values that are not valid or out-of-range.
Max degree of parallelism
Use this option to set the degree of threads per execution. The default value for Max degree of parallelism is set to 0, this means there is no limit to the number of processors.
When you are done, click the Next button to proceed to Editing and executing the result script.