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.

 

Check Database - Specifying arguments and options

 

 

Arguments

 

RadioButton 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.

 

RadioButton Repair with data loss

When this argument (REPAIR_ALLOW_DATA_LOSS) is used, all reported errors are repaired. These repairs can cause data loss.

 

RadioButton Fast repair

This argument (REPAIR_FAST) enables fast repair of errors which is maintained for backward compatibility.

 

RadioButton 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.

 

 

Options

 

CheckBox All errors

This option (ALL_ERRORMSGS) displays an unlimited number of errors per object.

 

CheckBox No info messages

This option (NO_INFOMSGS) suppresses all informational messages.

 

CheckBox 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.

 

CheckBox Estimate only

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.

 

CheckBox Physical only

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.

 

CheckBox 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.

 

CheckBox 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.