Click or drag to resize

SA0083 : Consider proactively checking the logical and physical integrity of all the objects in the database

The topic describes the SA0083 analysis rule.

Message

Consider proactively checking the logical and physical integrity of all the objects in the database

Description

The rule checks the current database for the last date when DBCC CHECKDB command was successful ran.

Periodically checking database consistency will help you identify possible database corruption earlier and avoid data loss.

Scope

The rule has a ContextOnly scope and is applied only on current server and database schema.

Parameters
NameDescriptionDefault Value
CheckPeriodInDays

Maximum number of days for running database integity check.

7

Remarks

The rule requires Analysis Context. If context is missing, the rule will be skipped during analysis.

Categories

Maintenance Rules

Additional Information

There is no additional info for this rule.

See Also

Other Resources