patternsqlMinor
Server Integrity Check CheckCommands question
Viewed 0 times
integritycheckcommandsservercheckquestion
Problem
I am trying to figure out what is the best CheckCommands option for ServerIntegrity check.
-
Should I leave the job defaults as is?
-
Should i run the
-
Should I leave the job defaults as is?
EXECUTE [dbo].[DatabaseIntegrityCheck] @Databases = 'USER_DATABASES', @LogToTable = 'Y'-
Should i run the
CHECKALLOC,CHECKTABLE,CHECKCATALOG option separately or is it included in the above? Same for the CHECKFILEGROUP option.Solution
If you run the base CHECKDB command, you don't need to run the others. The other commands make up what is run by the full command.
See:
-
CHECKDB From Every Angle: Complete description of all CHECKDB stages
-
CHECKDB From Every Angle: Consistency Checking Options for a VLDB
Breaking the full check into its constituent parts is sometimes done on very large databases where a full check in total is too time consuming or gobbles up too many resources.
The only CHECKDB option that results in a different full check (PHYSICAL_ONLY) runs fewer overall checks. It skips logical checks against the data and only checks the physical file structure.
See:
-
CHECKDB From Every Angle: Complete description of all CHECKDB stages
-
CHECKDB From Every Angle: Consistency Checking Options for a VLDB
Breaking the full check into its constituent parts is sometimes done on very large databases where a full check in total is too time consuming or gobbles up too many resources.
The only CHECKDB option that results in a different full check (PHYSICAL_ONLY) runs fewer overall checks. It skips logical checks against the data and only checks the physical file structure.
Context
StackExchange Database Administrators Q#246206, answer score: 9
Revisions (0)
No revisions yet.