Online Documentation for All SQLManager.net Products

Setting options


This step of the wizard allows you to customize database integrity check.

 

Service tasks - Datbase Integrity Check - Setting options

 

 

CheckBox Include Indices

The option indicates that indices are included in database integrity check.

 

CheckBox Limited Checking

Use this option if you need to restrict database integrity check with Physical Only or Data Purity conditions:

 

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

 

If RadioButton Data Purity option (DATA_PURITY) is enabled, the DBCC CHECKDB statement checks the database for column values that are not valid or out-of-range.

 

Exclusive access options limit the checks that are performed.

RadioButton Snapshot

Enable the option to use an internal database snapshot for the transactional consistency needed to perform database integrity checks.

RadioButton Lock Table

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 All error messages

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

 

CheckBox No info messages

This option (NO_INFOMSGS) suppresses all informational messages.