4

I am trying to figure out what is the best CheckCommands option for ServerIntegrity check.

  1. Should I leave the job defaults as is?

    EXECUTE [dbo].[DatabaseIntegrityCheck] @Databases = 'USER_DATABASES', @LogToTable = 'Y'
    
  2. Should i run the CHECKALLOC,CHECKTABLE,CHECKCATALOG option separately or is it included in the above? Same for the CHECKFILEGROUP option.

9

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:

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.

  • @eckes Ola's tool run DBCC CHECKDB. – Erik Darling Aug 26 at 14:58
  • @eckes okay, cool! – Erik Darling Aug 26 at 15:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.