Backup Overview
Chapter 3: Backing Up Microsoft SQL Server Databases 37
■
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.
Example: How DBCC Options Work
The following example illustrates how DBCC options work in conjunction with
Override Global Options on the Agent Backup Options dialog.
■
With Override Global Options specified, the DBCC options selected at the
database level will be the only DBCC options specified.
■
With Override Global Options not specified, all of the DBCC options specified
for the database and all of the DBCC options selected in the Global options
will be applied together.
On the Global Options/Agent Options tab, the Database Consistency Check
options that follow are specified:
■
After backup
■
Do not check indexes
On the Agent Backup Options dialog, Override Global Options is not selected and
the Database Consistency Check options that follow are specified:
■
Before backup
■
Continue with backup, if DBCC fails
Note:
To open the Agent Backup Options dialog, open the Backup Manager, click
the Source tab, browse to and expand the CA ARCserve Backup server,
right-click the CA ARCserve Backup database, and then select Agent Option from
the pop-up menu.
When you submit the backup job, CA ARCserve Backup applies the DBCC options
specified in logical order: Perform the DBCC before the backup starts. If the
DBCC fails, perform the backup. After the backup is complete, do not check the
indexes.
