Scheduling Database Consistency Checks (Windows)

You use the DBA Planning calendar to schedule the database consistency check on SAP database. A database consistency check performs a thorough check of the entire database. It examines all tables in the database to find out whether index and data pages are correctly linked and indexes are sorted in ported order.

This feature is only available if the user has sysadmin privileges or has impersonate permission as dbo.

Procedure

1. Schedule the database consistency check in the DBA Planning Calendar. For more information, seeScheduling an Action.
2. In the Action column, select Check Database Consistency.

   There are no parameters to select for this action.

   Note

   You can also set this action as a recurring job with the recurrence tab strip.

3. When the check has completed, check if it has finished successfully in the DBA Planning Calendar. If it is highlighted in red, there are inconsistencies or errors were generated during the check. For more information about the errors, double-click the task.

   The program log contains additional information about the task.

   Note

   • As of SAP NetWeaver 7.0 EHP2 and 7.2 and higher, the error messages for the DBCC check are also written to msdb database table. To display the output of all DBCC Checkdb jobs, select Jobs → Checkdb Job History.
   • Some error information is also recorded in the Windows Error Log. To locate the information in the log, look for SQL Server and SQL Executive entries made at the time the task ran.
4. If you discover any errors, contact your SAPconsultant. You must correct errors immediately to avoid serious problems with your system.