Checking the integrity of databases

Integrity checks must be conducted regularly so that any form of corruption on the database can be detected.

Use the DatabaseIntegrityCheck script to launch the following integrity checks:

• Integrity check on SYSTEM_DATABASES to be scheduled once a week at a different time from other jobs.

  EXECUTE [dbo].[DatabaseIntegrityCheck]
  @Databases = 'SYSTEM_DATABASES',
  @LogToTable = 'Y'

• Integrity check on USER_DATABASES to be scheduled once a week at a different time from other tasks.

  EXECUTE [dbo].[DatabaseIntegrityCheck]
  @Databases = 'USER_DATABASES',
  @LogToTable = 'Y'