Introducing Arcserve Backup Agents and Options › Using Agents › Agent for Microsoft SQL Server › Restoring Microsoft SQL Server Databases › Database Consistency Check (DBCC) Options

Database Consistency Check (DBCC) Options

A database consistency check (DBCC) tests the physical and logical consistency of a database. DBCC provides the following options:

After restore

Performs DBCC after the restore of the database.

Before restore

Performs DBCC before an Online Torn Page Repair restore of the database. (SQL Server 2000 or later, Enterprise Edition only.)

Do not check indexes

Checks the database for consistency without checking indexes for user-defined tables.

Note: The system table indexes are checked regardless of whether you select this option.

Check only the physical consistency of the database

Detects torn pages and common hardware failures, but does not check the data against the rules of the database schema. It still checks the integrity of the physical structure of the page and record headers, and the consistency between the page’s object ID and index ID. This option is available for Microsoft SQL Server 2000 or later. If this option is selected from the Global Agent Options tab, it is ignored for SQL Server 7.0 databases.

All error messages that are generated during the DBCC are recorded in the Agent for Microsoft SQL Server log file called sqlpagw.log. The log is located in the Backup Agent directory.